Turning N/A cells to blank Cells
 

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

Turning N/A cells to blank Cells
 

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

If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

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

Turning N/A cells to blank Cells
 

Try this

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

Mike

"amik" wrote:

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

Turning N/A cells to blank Cells
 

Hi,

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

"amik" wrote:

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

Turning N/A cells to blank Cells
 

Thanks Alot it works great

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

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