try
=IF(ISNA(yourformula),"",yourformula)

=IF(ISNA(LOOKUP(D4,{"Name1","Name2","Name3","Name4 ","Name5","Name6","Name8","Name9"},{"#1
VIP","#2
VIP","VIP","VIP","VIP","VIP","VIP","VIP"})),"",LOO KUP(D5,{"Name1","Name2","Name3","Name4","Name5","N ame6","Name8","Name9"},{"#1
VIP","#2 VIP","VIP","VIP","VIP","VIP","VIP","VIP"}))
--
Don Guillett
SalesAid Software

"MsBeverlee" wrote in message
...
Due the size restriction of the IF function, I have used the LOOKUP
function
for my conditional formula. It is yielding the results I want, but when
the
criteria does not match, the result is the error #N/A. Here is the
formula I
am using:

=LOOKUP(B4,{"Name1","Name2","Name3","Name4","Name5 ","Name6","Name8","Name9"},{"#1
VIP","#2 VIP","VIP","VIP","VIP","VIP","VIP","VIP"})

Is there anyway to use the IF function so that if the result of the above
formula = #N/A, the cell is blank. Or can I set a conditional format so
that
if it's #N/A, the cell is highlighted or font color different?

Also, with this same formula, is it possible to have the LOOKUP reference
more than 1 cell (i.e. =LOOKUP(B4 &" "& B5, . . . .)?

Thanks for your help.