ok, this was kinda stupid, and im not sure why they make you do this,
but i needed to add indirect() around the address:
Code:
--------------------
=IF(M200="","",MIN(INDIRECT((ADDRESS(MATCH("Client Aged A/R", $A$1:A198, 0), 10))):J200))
--------------------
anyways, now if anybody can help me figure out how to make the match
run backwards, that would be awesome....
right now it searches from A1 and finds the first "client aged a/r" on
the way down to A198; i want it to start at A198 and find the first
"client aged a/r" on the way up to A1
oh, and while it seems to be the logical solution just changing a1:a198
to a198:a1 doesnt work, it automatically changes it back
-ryan
--
ryan00davis
------------------------------------------------------------------------
ryan00davis's Profile:
http://www.excelforum.com/member.php...o&userid=37344
View this thread:
http://www.excelforum.com/showthread...hreadid=570458