Thread: Replace all values in a column with values using a mapping from another worksheet
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] garyusenet@myway.com is offline
external usenet poster
  
Posts: 33
Default replace #N/A with some other text ?
One last question!

How do I get excel to do the following?
Instead of writing #N/A for every cell it can't find a match for in the
vlookup, write 'unknown'. My Vlookup that is working is: -

=VLOOKUP(K2,biztypes!A:B,2,FALSE)

Thanks again!

Gary.

Reply With QuoteReply With Quote