meldarionqeusse
10/17/2017 - 11:43 AM

excel see if value is in a list

https://www.extendoffice.com/documents/excel/3962-excel-match-cell-value-to-list.html

See if a value is present in a list of values

see Find text in range of cells and return cell if not leave empty

.xlsx
content_copyfile_download
=IF(ISNUMBER(MATCH(C2,A2:A7,0)),1,0)