Vlookup Across 2 AND down two rows
 

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

Vlookup Across 2 AND down two rows
 

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.

Vlookup Across 2 AND down two rows
 

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


"Wrkn4alivn" wrote:

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

Vlookup Across 2 AND down two rows
 

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

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

Vlookup Across 2 AND down two rows
 

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

Thanks