Vlookup Across 2 AND down two rows

[Wrkn4alivn]

I am trying to reference GL account numbers, but Vlookup only will
produce the values in the row of what was found. How can I look up
what is over 2 columns but down 2 rows? There is no reference in the
first column for vlookup to find, and I need to keep that column first.

Ex.

1235 1524.24
1236 115242.24
1237 456.45
62.85
454.45 (I want this cell)
1238 856.45

 

[Pete_UK]

Use a combination of INDEX( ) and MATCH( ) - match will find the
relative position of 1237 in the first list (to which you can add 2),
then INDEX allows you to go to the same row in a different list.

Hope this helps.

 

[Ron Coderre]

Try something like this:

With your data in Cells A1:B6

D1: 1237
E1: =INDEX($A$1:$B$6,MATCH(D1,$A$1:$A$6,0)+2,2)
That formula returns 454.45

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[bj]

try something like
=index(C1:c100,match(1237,A1:A100)+2)

 

[Wrkn4alivn]

That did it! Now I am doing my happy dance.

Thanks