Thread: Getting rid of VLOOKUP N/A
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Getting rid of VLOOKUP N/A

Look in the help index for
ISNA
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WA" wrote in message
...
Lets say I implement the vlookup function and it displays #N/A in the cell
because it can't find what I am looking for - is there a way to change the
#N/A to a number or string of my choice?


Thanks,

W.A.

Reply With QuoteReply With Quote