Sarah has attended:
Excel Intermediate course
Formula
Have you got a formula for comparing two lists of values?
RE: 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