In other words, you want to find the *last* instance of 150 and return the
corresponding value from olumn L?

If that's the case try this:

A1 = 150

=LOOKUP(2,1/(E2:E1011=A1),L2:L1011)

--
Biff
Microsoft Excel MVP


"Sandy" wrote in message
...
I'm using 2007 exel and the vlookup function seems to be what I
need....Almost. I have a growing list of numbers, curently with over 1000
rows. I want to lookup a number in column E and get the corresponding
number
in column L, my range is E2:L1011. When I set up a vlookup it finds the
number 150 no problem however it starts looking at the top of the range at
E2. I want the function to start at E1011 and work its way up so I get
the
most recent entry. Any Ideas?