Hi All,
I am trying to figure out if there is another formula rather than VLookup.
When you select column “A” on tab Test will automatically populate column B and C, taking information from the tab “new”.
To make the Vlookup works I hade to put in the first position the subcategory, changing the original layout. If I move subcategory in the 3rd column can I use another formula to populate the columns “Category” & “cost type” (I was thinking Index or Index match) but I am not very familiar with Index formula.
Thanks
Ale

Attached Files

test.xlsx (67.3 KB, 12 views)