T

#### Tokeroo

=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.