ok, i have almost figured it out, here is what i have so far:

Code:
--------------------
IF(L200="","",MIN(ADDRESS(MATCH("Client Aged A/R", $A$1:A198, 0), 10):J200))
--------------------


but there is a formula error somewhere, i dont understand because if i
take out the address part and put in J7 it works, and the address part
put into another cell returns J7, so i cant figure out why exactly it
doesnt want to work, ill keep playing with it, but maybe someone else
out there can help.

the second problem is that i want the match to work backwards, right
now it returns the highest cell in the range with "Client Aged A/R", i
want it to return the lowest cell in the range with value "Client Aged
A/R", that is why i have $A$1 as the upper limit of the range, because
it should search all the way up for the first possible value, anybody
know how to do this?


--
ryan00davis
------------------------------------------------------------------------
ryan00davis's Profile: http://www.excelforum.com/member.php...o&userid=37344
View this thread: http://www.excelforum.com/showthread...hreadid=570458