What are you trying to do? Your second formula says "If the VLOOKUP returns
an error, then "X", else "". If your VLOOKUP returns no errors then "" will
be returned. But from your question it sounds like you're looking for
VLOOKUP to intentionally return an error?

Dave
--
Brevity is the soul of wit.


"scheduler" wrote:

Thanks to all that have gotten me this far, but still need a little more help.


I can get the "X" to appear in this formula:
=IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"","X")

But cannot get it to appear in this formula:
=IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"X","")

I need the second formula to work in this scenario
As the EMP's are placed in columns A,B,C,D I need
the x's to appear in columns k,l,m,n,o,p

A B C D
MON TUE WED THU
1) #1 #2
2) #1
3) #3 #2
4) #4


J K L M N O P
EMP M T W R F S
#1 X X
#2 X X
#3 X
#4 X