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
|