Thread: IF Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scheduler scheduler is offline
external usenet poster
  
Posts: 21
Default IF Value
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","")

Why?????????????
Reply With QuoteReply With Quote