Vlookup lookup value will be on last column

[emina002]

Hello I just need a suggestion how can I use vlookup another sheet if my lookup value will be on the last column of my other sheet.see attachement for example.

I have 2 sheet.Sheet1 and Sheet2.As usual I have to look for the value on sheet2 using vlookup. Im going to use vlookup and lookup up value on Sheet2 but the value is in Column D and I want to return the value of A:C of sheet2 in sheet1 if its found.how can I do that?thanks.

[ConneXionLost]

Try using the INDEX & MATCH functions instead:

Please Login or Register  to view this content.

Cheers,