This video shows the steps for fixing those text/number problems, and there are written steps below.įor example, your lookup table might have “numbers” that are really text. One common cause for a MATCH function error is trying to match:Įxcel sees those as completely different things, even if they look the same on the worksheet, so they don’t “MATCH”. There are more examples on the INDEX and MATCH page of my Contextures site.Īnd now, let’s do some MATCH troubleshooting. It has four MATCH examples, so you can see different ways to use it. And if numbers aren’t the problem, I’ve got a couple of other things to check too! MATCH Function Examplesīefore we start troubleshooting the MATCH function, here’s a short video that shows how the function works. The reason for that could be numbers that Excel sees as text, and here are a couple of ways to fix that problem.
Sometimes, a MATCH formula returns an #N/A error, even if the value you’re looking for is in the lookup table.
