Vlookup Function

K

keycomboy

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
 
D

Don Guillett

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
Click to expand...

Why? Homework?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating: MAX & MIN 3
Vlookup Loop 1
Simple Vlookup Looping 2
Using Vlookup, hyperlinks do not work 1
lastrow function help 6
Vlookup result in a message box 10
vlookup issue 2
Vertical lookup with a lookup value that returns multiple matches 3

Top