View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tinkerbell.1178[_2_] Tinkerbell.1178[_2_] is offline
external usenet poster
 
Posts: 1
Default VLOOKUP - Return value of the cell below the formula's answer

I'm using VLOOKUP and the value being searched for in the table array covers
4 rows (ie header "April" - search value - is in merged cells A12:A15). So
when I enter "return value in column 3(C)", it returns the value in the
highest row - being cell G12. As there are 4 different entries for April (in
cells B12, B13, B14 & B15), the lookup needs to return each of the B cells in
different formulas.

I can't move part of argument to column headers, as that is where my account
manager names a hence return value in column 3(C). Other cells return
values from columns 4 - 9 (D - I).

Is there a way to add to the formula to return the value BELOW the one found
with VLOOKUP? ie return value in cell R-1?

Thanks