Hi,
I have a list of values in range A2:A20000 (many of them duplicates), and then another list of values in range B2:B200 (all unique)
List of values in column A changes dynamically while column B is static.
I need a formula - if there's one - which would cross-check two columns and return an error message if a value in column A is not found in column B (exact match). In ideal case, I would need the mismatched value listed/called out specifically (if there are several mismatches, it's ok to flag just the first one). However, at the very least I need some kind of error if there's a mismatch to be able to look into this manually...
I have a list of values in range A2:A20000 (many of them duplicates), and then another list of values in range B2:B200 (all unique)
List of values in column A changes dynamically while column B is static.
I need a formula - if there's one - which would cross-check two columns and return an error message if a value in column A is not found in column B (exact match). In ideal case, I would need the mismatched value listed/called out specifically (if there are several mismatches, it's ok to flag just the first one). However, at the very least I need some kind of error if there's a mismatch to be able to look into this manually...