Vlookup

[troy_yy]

Dear all:

i need your help to get a formula to lookup for some values.

Please check atachment for more information.

Example:

Sheet 1
A1: TOM B1: 3
A2: ADAM B2: 5
A3 SARA B3: 30
A4: SAMI B4: 70

Sheet 2:
A1: SARA B1: (i want formula to lookup for A1 and get B3 from Sheet 1)
Thanks a lot.

[zbor]

Hre, try this:


=INDEX(Data!G:G;MATCH(A2;Data!B:B;0))

or

=INDEX(Data!G:G, MATCH(A2, Data!B:B, 0))

[davesexcel]

=VLOOKUP(A2,Data!$B$2:$C$214,2,0)