vlookup and offset

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hi, I'm trying to create a function that returns the
value of a cell one row below a cell that is vlookup'ed.
It would be along the lines of "=offset(vlookup
(I23,K16:L72,1),1,0)" except this doesn't work, I assume,
because vlookup returns a value, while offset accepts a
reference... How would I go about doing this...
Similarly, "=offset(cell("address",vlookup
(I23,K16:L72,1),1,0))" doesn't work either..

Thanks in advance,
Jordan
 
Sorry, I should have told you "=offset(vlookupfunction is going to work, no? But thanks for the help
and speedy response.
 
Never mind my previous post... Your suggestions work
perfectly. I failed to see that you were using two
different arrays for the index and the match functions.
Thanks again guys!
 
Back
Top