Turning N/A cells to blank Cells

[amik]

Is there somthing I can insert in to a vlookup formula so that if the cells
comes up N/A that it will be shown as a blank cell.

=VLOOKUP(D21,'Postpaid New'!$L$2:$BC$860,7,FALSE)

Any advice would be appreciated

 

[Jacob Skaria]

Use IF(ISNA(formula),"",formula) to handle this..

If this post helps click Yes

 

[Mike H]

Try this

=IF(COUNTIF('Postpaid New'!$L$2:$BC$860,D21)=0,"",VLOOKUP(D21,'Postpaid
New'!$L$2:$BC$860,7,FALSE))

Mike

 

[Eduardo]

Hi,

=IFERROR(VLOOKUP(D21,'Postpaid New'!$L$2:$BC$860,7,FALSE),0)

 

[amik]

Thanks Alot it works great

Use IF(ISNA(formula),"",formula) to handle this..

If this post helps click Yes