The user trying to compare type A column with type B column if they match or not, which formula would provide the desired result?
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
|How to use multiple match, including a number between two specified values|
|How to obtain validation list values from 3 columns based on INDEXMATCH of value offset from cell|
|How to use match formulae: input data range based on cell value|
|How to use a formula to return multiple matches in separate rows|