#NO MATCH on simple VLOOKUP
Answers

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 indexmatch function is also buggy when used in a range that is a multicolumn, I made the range a onecolumn.
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.

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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!