Thanks:  0
Likes:  0

1. Chris,

You have mail.

2. Zac,

your formula changes in cell B6

3. =IF(ISERROR(INDIRECT("a"&MIN(IF(MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0)>MATCH(B4,\$A\$1:\$A\$13,0),MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0),99999)))),"",INDIRECT("a"&MIN(IF(MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0)>MATCH(B4,\$A\$1:\$A\$13,0),MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0),99999))))

This is the correct formula.

[ This Message was edited by: zacemmel on 2002-05-06 10:38 ]

4. On 2002-05-06 10:37, zacemmel wrote:
=IF(ISERROR(INDIRECT("a"&MIN(IF(MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0)>MATCH(B4,\$A\$1:\$A\$13,0),MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0),99999)))),"",INDIRECT("a"&MIN(IF(MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0)>MATCH(B4,\$A\$1:\$A\$13,0),MATCH(\$A\$1:\$A\$13,\$A\$1:\$A\$13,0),99999))))

This is the correct formula.

[ This Message was edited by: zacemmel on 2002-05-06 10:38 ]
if I make cell A4 blank, I get nothing back except "mary" in B1

5. also Zac, it might have been slightly useful to have told us that this is an array-entered formula, entered with CNTRL SHIFT ENTER, as oppose to a regular formula

6. The data has to be contiguous and adjacent. I thought it was inferred that it was an array formula. I guess not

7. okay, so *if* it's adjacent and contiguous and you don't mind editting the formula to fit your exact data range each time, remembering not to put it in the first row, I concur that it works.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•