Thread: how can I check the value 1 cell against the values of entire row
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
quimrider
 
Posts: n/a
Default how can I check the value 1 cell against the values of entire row

I have a similar situation. I need the result to be a logical
TRUE/FALSE. I cannot figure out how to use the #N/A value in a logic
test. Basically I need to see if the reference cell value is in the
list and return TRUE if its and FALSE if it isnt. The only stumbling
block is how to deal with the #N/A error. Any suggestions?


--
quimrider
------------------------------------------------------------------------
quimrider's Profile: http://www.excelforum.com/member.php...o&userid=29009
View this thread: http://www.excelforum.com/showthread...hreadid=490747

Reply With QuoteReply With Quote