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.