Error in VLookup formula

Hi All,

I want to learn VLOOKUP formula in this following problem.

HTML Code: 

I am attaching the file for the same. Could plz suggest me where i am wrong in this formula. ?

Regards,
Upananda

VLOOKUP won't work in that layout. VLOOKUP matches one instance of a sought value. You have 11 instances of each.

You need to use a basic INDEX/MATCH. Like we've used in the past. If you're willing to eliminate those empty cells in Sheet2 by putting in the company names all the way down, this will work in OutPut cell D3...copied down and then across:

=INDEX(Sheet2!C$3:C$112, MATCH(Output!$A3 & "-" & Output!$B3, INDEX(Sheet2!$A$3:$A$112 & "-" & Sheet2!$B$3:$B$112, 0), 0))

Hi JB,

I am greatful to you for ur help. I know without ur help, I wouldn't have come so far.

With Sincere Regards,