View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
one way:
=MAX(INDIRECT("B" & VLOOKUP(...#1) & ":B" & VLOOKUP(...#2)))

--
Regards
Frank Kabel
Frankfurt, Germany

"Rachel_M" schrieb im Newsbeitrag
...
Hi, I'm trying to use returned values from VLOOKUP functions as the

row
numbers in the range of a max function.

For example the first VLOOKUP gives me 9 and the 2nd VLOOKUP gives me

15,
and I want the maximum of cells B9:B15.
Thanks for any help!
Rachel