Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error bars display | Charts and Charting in Excel | |||
Error bars-repost | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
error "module not found" | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |