Forum Discussion

NativeWest's avatar
NativeWest
Copper Contributor
Jul 08, 2024

Macro or formula to analyze data in a range for similar data in another range

Hi,

I'm not even sure if this is possible but I'm hoping to find a way to have excel make a best guess and return the value in a dataset. Using the example below Excel would read the values in column D and enter the closest match from column F next to it in column E. So FACBK*3VCAQ3YFL2 would result "Facebook" in cell E2. I'm not looking for perfection, just a head start.

 

Thank you in advance!

Ryan

Resources