=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.

 

[arthurbr]

Perhaps tell us what is going wrong? Which error do you get ?

 

[Bedford]

Perhaps tell us what is going wrong? Which error do you get ?

Actually it's not giving an error the cell is merely blank?

 

[Fluff]

What happens if you just use this

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

 

[Bedford]

What happens if you just use this

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

strangely, same, blank cell? Very confused.

 

[Fluff]

Check that you don't have any conditional formatting, or custom cell format in place.

 

[Bedford]

Check that you don't have any conditional formatting, or custom cell format in place.

No conditional formatting, the original formula was an array which also was not showing any result, the array was; =IF(ISERROR(INDEX('CONSUMER DATA'!$AK$5:$AK$1631,SMALL(IF('CONSUMER DATA'!$T$5:$T$1631<>"",IF('CONSUMER DATA'!$T$5:$T$1631=$AZ$3,ROW('CONSUMER DATA'!$T$5:$T$1631)-ROW('CONSUMER DATA'!$T$5)+1)),ROWS('CONSUMER DATA'!$T5:T$5)))),"",INDEX('CONSUMER DATA'!$AK$5:$AK$1631,SMALL(IF('CONSUMER DATA'!$T$5:$T$1631<>"",IF('CONSUMER DATA'!$T$5:$T$1631=$AZ$3,ROW('CONSUMER DATA'!$T$5:$T$1631)-ROW('CONSUMER DATA'!$T$5)+1)),ROWS('CONSUMER DATA'!$T5:T$5))))

 

[Fluff]

No conditional formatting,

What about cell format?

 

[Bedford]

What about cell format?

Set as currency

 

[Fluff]

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