ExcelBanter - Vlookup Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup Function (https://www.excelbanter.com/excel-programming/450049-vlookup-function.html)

Vlookup Function

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

Don Guillett[_2_]

Vlookup Function

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?

All times are GMT +1. The time now is 11:47 PM.