Forum Discussion

rockyb855's avatar
rockyb855
Copper Contributor
Jun 24, 2024

Fuzzy match in conditional formatting

I think I am overthinking something that should be easy.

If I have a column with lab names. Sheet1 B:B

And I want to highlight all values that are in a secondary list. Sheet2 B:B.

But the secondary list might be a partial match in Sheet1.

Such as Sheet2 might have Hemoglobin but Sheet1 might have values Hemoglobin C and Hemoglobin F.

I have been messing with vlookup("*"& xxx & "*"

But I might be overthinking.

Can anyone help?

thanks

Resources