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

VBA Coding Help for Beginner 0
Conditional Formating: MAX & MIN 3
Calculate the median value before a specified list 0
Word macro that can call cells out of Excel for a find and replace 0
Need help to fix vlookup function in macro 1
Autonumber field in Excel that behaves the same as Access 0
Is this possible? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top