View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wrkn4alivn
 
Posts: n/a
Default 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