Vlookup Function

  • Thread starter Thread starter keycomboy
  • Start date Start date
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
 
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

Vlookup error 5
Conditional Formating: MAX & MIN 3
Vlookup Loop 1
Simple Vlookup Looping 2
Using Vlookup, hyperlinks do not work 1
vlookup issue 2
lastrow function help 6
Vlookup result in a message box 10

Back
Top