Hi Guys,
I need two (2) formulas for the following please:
Compare ALL of the values in 1 range to ALL the values in the other range and give result if ANY cells match or don’t match.
(more than 1 cell may match and that’s ok)
I don’t want to compare just 1 cell (eg B1) in range B1:B200 to any cell in range A1:A500
The values will be Integers for one formula and text for the other.
Something like this:
If(Match(Any cell in B1:B200(or defined name) to Any cell in A1:A500), then give “Match” if matched otherwise give “No Match” if not matched.
These formulas will also be used with a *defined name* instead of a range sometimes. I assume ‘Name’ will just replace ‘Range’ in formulas.
They will be used separately throughout the workbook to compare *different* ranges.
Thanks
MaxTrax
I need two (2) formulas for the following please:
Compare ALL of the values in 1 range to ALL the values in the other range and give result if ANY cells match or don’t match.
(more than 1 cell may match and that’s ok)
I don’t want to compare just 1 cell (eg B1) in range B1:B200 to any cell in range A1:A500
The values will be Integers for one formula and text for the other.
Something like this:
If(Match(Any cell in B1:B200(or defined name) to Any cell in A1:A500), then give “Match” if matched otherwise give “No Match” if not matched.
These formulas will also be used with a *defined name* instead of a range sometimes. I assume ‘Name’ will just replace ‘Range’ in formulas.
They will be used separately throughout the workbook to compare *different* ranges.
Thanks
MaxTrax