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

recognising if a number is in a list
 

try this formula and see if it works

=IF(SUMPRODUCT((A2:A20=B5)*A2:A20)=0,"Not in list","In list")

--


Gary


wrote in message
ps.com...
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

recognising if a number is in a list
 

Paul,

Type the below code in the cell B6.

=IF(COUNTIF(A2:A20,B5)0,"Yes","No")

Regards,
Sriram

" wrote:

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

recognising if a number is in a list
 

=vlookup(b5,a:a,false)

will enable you to add more and more numbers to col a

Rich


" wrote:

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