Get instant live expert help on I need help with approximate match excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have two columns of URLs in Excel. The first set of URLs are from an old website and the second set of URLs are from the new website. I need a formula so I can do an approximate match on the text so the new URLs match the queries of the old ones so I can put redirects on them.
Solved by T. W. in 20 mins
a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match.
Solved by S. W. in 20 mins
Hi i want to calculate the approximate yearly growth rate based on 9 months of data, plus then calculate the increase in traffic.
Solved by V. D. in 12 mins
My example is: column A has customer name "EZ Cater" column B had customer number "C-00120" column C has text "AR Pymt - EZ Cater". I need a formula that makes following function if column C contains text from column A is equal with column B (customer number). Vlookup doesn't work here I tried approximate match but doesn't work.
Solved by K. D. in 21 mins
Hello, I am trying to do a match in excel. to match names
Solved by E. H. in 26 mins