View Single Post
  #1   Report Post  
Rachel_M
 
Posts: n/a
Default cell value as a row number in a function?

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