On Thursday, May 1, 2014 9:04:01 AM UTC-5, wrote:
Hi,

I am trying to use the vlookup function to do the following:



1. find the lookup value in column 1

2. find the highest value in the same row as the lookup value

3. return the value form the first row in the same column as the highest value



Hope this makes sense



Thanks for any help

Why? Homework?