All,
I have used VLOOKUP on numerous occasions but cannot figure out what I am doing wrong here. I have attached an extract of the sheet.
Essentially I have a calculation which produces a series of values in column O. I want to return (in cell E3) the corresponding value in column E to that in O.
The lookup value is located in E2. This look value will vary as it is return as the Maximum value found in column O.
All I get is #N/A
It is spoiling my day, please help!
many thanks.
Bookmarks