=IF(ISNA(INDEX....

[Bedford]

I've used this formula to return a result in other workbooks, for some strange reason I can't get it to work in this new workbook, can't see what I'm missing?

=IF(ISNA(INDEX('CONSUMER DATA'!$AK$5:$AK$1654,MATCH(AZ3,'CONSUMER DATA'!$T$5:$T$1654,0))),"",INDEX('CONSUMER DATA'!$AK$5:$AK$1654,MATCH(AZ3,'CONSUMER DATA'!$T$5:$T$1654,0)))

Anyone can help.
Thank you.

 

[Bedford]

In that case in Options, advanced scroll down to "Display options for this worksheet" is the checkbox by "Show a zero in cells..." checked?

It wasn't checked off, so I checked it and it showed zero.

 

[Fluff]

That probably means that the cell in col AK is either empty or contains 0 for the row that was matched.

 

[Bedford]

That probably means that the cell in col AK is either empty or contains 0 for the row that was matched.

I now remember what I did, sorry for the goose chase. In the destination cell, BH38, the formula looks for only the first item in column AK that is based on this part of the formula; MATCH(AZ3,'CONSUMER DATA'!$T$5:$T$1654,0)). So if there are more than one row that contains a match to AZ3, it only picks up and inserts the first match, if the entry is in a second, third or otherwise row below, it won't pick it up, not sure why that is, but that's how this formula works. In this case, there are 5 rows with the same data entered in column "T" which is what AZ3 is looking for, it seems to only pick up the first row, and no other? But my immediate problem is solved, and I really appreciate the time and help.

 

[Fluff]

Glad it's sorted & thanks for the feedback.

 

[Bedford]

Glad it's sorted & thanks for the feedback.

Thanks again, have a great weekend.