Using Concatenated cell information in a VLookup

[Emieden]

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

[Special-K]

This
=VLOOKUP(A4&B3,Lookup,4)
shoudl be this
=VLOOKUP(A4&B$3,Lookup,4)

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[tim201110]

=VLOOKUP(A2&B1,Lookup,4,)

[Emieden]

Ah thank you so much. It was just a case of missing an end comma thank you.