Thread: #N/A Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Tokeroo@gmail.com is offline
external usenet poster
 
Posts: 1
Default #N/A Error

formula in question
=IF($D$23="","",VLOOKUP($D$23,'Registration
Page'!A1012:Y2010,21,FALSE))

my problem is D23 has another vlookup equation in that cell, so when it
doesn't display any information i get a #N/A. is there a symbol i can
use to tell excel that when it doesn't find a result but finds an
equation to print "0"

i.e.
=IF($D$23="FUNC","0",VLOOKUP($D$23,'Registration
Page'!A1012:Y2010,21,FALSE))


Thanks in Advance
J.