Formula

Hello Sarah
Thank you for your question

This depends on how you are trying to compare them, but you could try VLOOKUP. Highlight the first list and name it as range 1, ensuring that the first column is the column you want to compare. Then use the vlookup formula to see if values in your list are present in your other list.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress