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
I think I am overthinking something that should be easy.If I have a column with lab names. Sheet1 B:BAnd 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 Read More
