ExcelBanter - recognising if a number is in a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - recognising if a number is in a list (https://www.excelbanter.com/excel-programming/371556-recognising-if-number-list.html)

[email protected]

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

All times are GMT +1. The time now is 06:02 AM.