[FN-2199]

Originally Posted by 6o4__boi

https://www.mrexcel.com/forum/excel-...no-values.html

or hlookup if the values you're cross referencing are in a row

That link is your answer!

From the screencap you gave us, it would look like this:

=IF(ISNUMBER(MATCH(Cell number,Range you want to cross reference,0)),"Yes","No")

Plug this into your "eligible superstar" cells and it will return the values.