First, match can be used to find an exact match or an approximate match. In,
this case, daddylonglegs is using an approximate match. The match function
is used to return the index number of the largest value that is smaller than
or equal to the value being sought (2 in this case). However, the array has
to be sorted ascending (see help for match function requirements) which
precludes using [array]="client aged a/r" because that will return 1's and
0's and won't meet the ascending order requirement. 1/array="client aged a/r"
will return 1's and #DIV/0! which apparently will satisfy the sort
requirement.


"ryan00davis" wrote:


both of those functions actually work, i think i might have been using
control enter instead of control shift enter.

thanks a lot, i have a working function so im no longer in any hurry,
but i dont really understand how that index function works.

im not sure why the function has 1/([array]="client aged a/r")

first i dont really get why this has 1 divided by the rest. is that
what makes it go backwards?

also if i look in the help, it says index returns the cell value or the
reference to the cell value, and control shift enter is what makes it
return an array, is this correct?


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