Excel Check If In List

[Solved] Excel Check If In List | Basic - Code Explorer | yomemimo.com
Question : excel check if in list

Answered by : aashit-vyom

=IF(ISNUMBER(MATCH(B2,A:A,0)),1,0)
B2 is value to be looked up
A:A is list Range

Source : https://www.extendoffice.com/documents/excel/3466-excel-check-if-value-is-in-list.html#:~:text=Besides%20the%20Find%20and%20Replace,0%2C%20that%20is%20not%20exist. | Last Update : Mon, 10 May 21

Answers related to excel check if in list

Code Explorer Popular Question For Basic