using AND with IF(ISNA...

[ronmaltase]

Hello, I’m using the great formula (which looks at an array and returns the unique values) and I added ISNA to remove the NA’s due to blanks – still works great. What I need to do (I think) is add an AND so that I can add some criteria to this IF(ISNA. Any Ideas?
=IF(ISNA(INDEX(CALCULATION!$D$3:$D$1001, MATCH(0, COUNTIF($A$1:A1, CALCULATION!$D$3:$D$1001),0))),"",INDEX(CALCULATION!$D$3:$D$1001, MATCH(0, COUNTIF($A$1:A1, CALCULATION!$D$3:$D$1001),0)))
-Thanks, Ron M.

[Pete_UK]

What other criteria do you want to add?

Pete

[ronmaltase]

This formula is looking at another sheet named (CALCULATION) which contains all USERS. On that “calculation” sheet I’ve got logic that does a VLOOKUP on the users (that I don’t want to see) and doesn’t print their daily cash collections based on the VLOOKUP (because I don’t want to see their totals). So I was thinking that if I look at one of the fields on the calculation sheet that doesn’t get populated (because of the VLOOKUP), then I could get this formula to INGORE that user.
I was thinking IF(AND(S3=””,ISNA(INDEX… But that doesn’t work. I don’t know what the hell I’m doing…