Thread: Turning N/A cells to blank Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amik amik is offline
external usenet poster
  
Posts: 15
Default 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
Reply With QuoteReply With Quote