Sort the lookup table Descending and use -1 as 3rd argument
?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ryan00davis" wrote in message
...
|
| i want to make match run from bottom to top, here is the formula im
| working with:
|
| (ADDRESS(MATCH("Client Aged A/R", A$1:$A198, 0), 10))
| --------------------
|
|
| right now it matches from A1 to A198 and returns the address of the first
| time it sees "Client Aged A/R", i really want it return the last time it
| sees "Client Aged A/R", which esentially would be the same thing as going
| from a198 to a1 and returning the first.
|
| thanks in advance
| ryan
|
|
| --
| ryan00davis
| ------------------------------------------------------------------------
| ryan00davis's Profile: http://www.excelforum.com/member.php...o&userid=37344
| View this thread: http://www.excelforum.com/showthread...hreadid=570881
|