Thanks to you as well, because that worked too!

"Peo Sjoblom" wrote:

One way

=MAX(INDEX(B:B,9):INDEX(B:B,15))

replace 9 and 15 with your respective vlookup

can look like this

=MAX(INDEX(B:B,VLOOKUP(E1,Sheet2!A2:B27,2,0)):INDE X(B:B,VLOOKUP(F1,Sheet2!A2:B27,2,0)))



Regards,

Peo Sjoblom




"Rachel_M" wrote:

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