Excel excel vlookup function

[rbul1]

column B column E column H
2 29000

4 39172 29000 1255 35
5 39447 27500 975 114
6 40585 31250 985 56
7 40977 33125 1005 45

=VLookup(E$4,E$4:H$7,2)

My formula returns the 1st value regardless of whether E5,6,&7 are larger or not.

Returns 1st number(29000) whether function contains True or False as the last formula entry.

 

[SlimJim]

I am no expert on Excel but the formula you have given
VLookup(E$4,E$4:H$7,2)
I believe looks for the first occurrence of the value in E$4 in the table E$4:H$7 and then returns the value in the second column of that table. If that is what it means that inevitably it is going to choose the first row as E$4 is the first row value in the first column of the table.

What exactly are you trying to pick out?

 

[rbul1]

VLookup solution

Thanks for the response SlimJim,

I AM TRYING TO REURN THE VALUE IN COLUMN 2 THAT CORRESPONDS TO THE LARGEST NUMBER VALUE OF THE "LOOKUP_VALUE" IN COLUMN 1.
Sorry about the caps I didn't realize I had hit caps lock.

 

[SlimJim]

Try

VLOOKUP(MAX(E$4:E$7),E$4:H$7,2,FALSE)

I've tried this on a simple data table and it seems to do the job

 

[rbul1]

VLookup

Thanks SlimJimI last used your formula on a QPRO worksheet years ago and could not remember the MAX aspect!

I really appreciate your responses.