Hello everyone. I'm new here and excited to share and answer. I've ran into several situations were I need to compare a list of values/text to see if they
consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar situations. This works best if the ranges are in tables.
Would enjoy hearing you thoughts. Thank you!
=IF(LARGE(XMATCH(LOOKUPValueRange,LOOKUPTableRange),1)-SMALL(XMATCH(LOOKUPValueRange,LOOKUPTableRange),1)=ROWS(LOOKUPValueRange)-1,"Match","No Match")
From here you can easily find and go to the match. The problem is....what if there are duplicate matches? Would appreciate any suggestions. No VBA solutions for this one, sorry.
consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar situations. This works best if the ranges are in tables.
Would enjoy hearing you thoughts. Thank you!
=IF(LARGE(XMATCH(LOOKUPValueRange,LOOKUPTableRange),1)-SMALL(XMATCH(LOOKUPValueRange,LOOKUPTableRange),1)=ROWS(LOOKUPValueRange)-1,"Match","No Match")
From here you can easily find and go to the match. The problem is....what if there are duplicate matches? Would appreciate any suggestions. No VBA solutions for this one, sorry.
