VLookup with Multiple Criteria Please Help

[sandraphysio]

Hi,
Here is my formula:
=VLOOKUP(G9,H9,J9,Sheet2!I:J9,L9,N9,17,False)

This is what I was trying to do
Lookup column G9 H9 J9 in Sheet 1 (as both columns make a unique identifier)
Lookup column J9 L9 N9 in Sheet 2 (as both columns make a unique identifier) and place Column from Sheet 2 COLUMN R9 into Column W9 in Sheet1

 

[RickXL]

Hi,

I think you need to use INDEX and MATCH.

What is the size of the lookup table in sheet2, please? Does it start at row 9 and where does it end?

Thanks,