VLookup from two cells instead of one

Hi

I need to lookup data from two cells in a row and find a similar row with same data in a different sheet, in order to return the data from a specific cell in that row.

Can this be done using Vlookup or do I need another formula?

Rgds
Mikael

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

One way:

=IF(A4="","",IFERROR(INDEX(Data!$D$4:$D$100,MATCH(1,(Data!$B$4:$B$100=A4)*(Data!$C$4:$C$100=B4),0)),""))

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.