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

​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  Read More

​