Dear all,

I have a table (which I'm trying to attach here but I can't see it)

I want to use 2 criteria to bring back the information in another cell. So I have concatenated those cells with the formula =CONCATENATE(B22,C22)

Then I go to the table and use =VLOOKUP(A2&B1,Lookup,4) but it brings back a completely different cell somewhere else in the table.

Concatenate table.PNG

Thank you so much