I have two lists. I'm trying to write a formula, so that excel will look in one list to see if it can find any of the information in the other list, and if so, it will display X. So that if anyone of the names on this list becomes present in this other list, the cell will display x. Thanks for the help
1 Answer
Say we have the short list in column A and the long list in column D, in B1 enter:
=IFERROR(MATCH(A1,$D$1:$D$21,0),"")
and copy down. Then in another cell enter:
=IF(COUNT(B:B)>0,"X","")
LOOKUP
,VLOOKUP
,INDEX
, andMATCH
, and search Super User. Try to solve this yourself (or find an equivalent question that's been answered; there's probably at least one). If you get stuck, tell us what progress you've made and where you're having trouble.