Thread: recognising if a number is in a list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paulwes@christchurchcasino.co.nz is offline
external usenet poster
  
Posts: 8
Default recognising if a number is in a list
Hi
I have a list of numbers in cells A2:A20, I am entering numbers into
B5 and am looking for a formula (in B6) that will tell me (yes/no) if
the number is in the list. Can anybody please help.
Thanks

Reply With QuoteReply With Quote