Jtdylktuy

-2 Here is the current table: I would like it to look like this: As you can see in the original table, some people don't have data (paid up) for the categories of "rent" "late", "utilities", etc. I have tried vlookup and it works okay, but I can't get the data per person without changing the array table per person. microsoft-excel worksheet-function vlookup share | improve this question edited Feb 6 at 3:03 angelofdev 929 1 20 asked Nov 6 '18 at 17:18