Reverse VLOOKUP?

[brett.kaplan]

Is there a way to do a reverse vlookup? That is, instead of searching
top down for a matching field, it will search bottom up? This way, if
there are duplicate entries in the lookup array, it will find the last
one instead of the first?

I cannot resort the table since it is in a separate workbook that
someone else updates. I've considered adding a worksheet and linking
it to the other book with my top row being the other book's last, and
working it out that way, but is there a way to do it without adding a
sheet?

Thanks!

 

[Dave Peterson]

=LOOKUP(2,1/(A1:A999="yourvalue"),b1:b999)

(Make that 999 big enough to extend past the last possible row--but don't use
the whole column.)