#NO MATCH on simple VLOOKUP

Rennel Apolinares

I just made a workaround on this buggy VLOOKUP. I am suspecting that if a cell you are referencing is a formula, it creates a bug in the vlookup function. Mine has quite a length of formula in it. But this is how I did it.

The MATCH function has done a good job in finding the position of the referenced cell from a list. Then I used the INDEX function. Since I also discovered that the index-match function is also buggy when used in a range that is a multi-column, I made the range a one-column.

In summary my formula now looks like this.

INDEX(range/column of where the OUTPUT is from, MATCH(the cell of the value you will be looking, range/column of the list where the value is sought, false).

This only works if the MATCH function works in your sheet.

I hope this helps.

bradley collins

It appears a change was made in 2018 that's generating this problem. What's crazy is I'm working on a sheet that both returns the correct result AND gives the error in other fields.