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
|