Thread: VLOOKUP
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default VLOOKUP
Maybe

=IF(ISERROR(VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE )),"",VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE))

Mike

"pm" wrote:

I'm getting an error "N/A" in the cell this formula is located in because
nothing is populated in the first column. How do I "" the error?

Thanks.

=VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)
Reply With QuoteReply With Quote