Thread: How do I remove the #div or N/A and make it 0 when using VLookup?
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon Lloyd[_291_] Simon Lloyd[_291_] is offline
external usenet poster
  
Posts: 1
Default How do I remove the #div or N/A and make it 0 when using VLookup?

Christian Hoedeman;400509 Wrote:
How can I use the formula IF(ISERROR) or ISNA etc., if i have like 6
verticallookups in one cell? It is possible that 3 of them have an
output and
the other 3 are NA.

Thanks in advanceProvide your formula and we will help you with that :)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=89297

Reply With QuoteReply With Quote