Thread: IF(ISNA(Hlookup question

Hi everybody, I am working on a If statement that is working but when there is no data I keep getting #N/A. If some one can help me with what to add where to make it stop displaying #N/A and just be a blank if no data I would appreciate it.

Below is my code
=IF(ISNA(HLOOKUP($D$6,'Pivot AM'!$A$11:$L$19,2,FALSE)),HLOOKUP($D$6,'Pivot AM'!$A$85:$L$89,2,FALSE),HLOOKUP($D$6,'Pivot AM'!$A$11:$L$19,2,FALSE))

Thanks for your time and any help.

Try:

=IF(ISNA(HLOOKUP($D$6,'Pivot AM'!$A$11:$L$19,2,FALSE)),IF(ISNA(HLOOKUP($D$6,'Pivot AM'!$A$85:$L$89,2,FALSE)),"",HLOOKUP($D$6,'Pivot AM'!$A$85:$L$89,2,FALSE)),HLOOKUP($D$6,'Pivot AM'!$A$11:$L$19,2,FALSE))