confusing formula results.
I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae.
I've written a column formula to add the values in two of these vlookup columns and in some of the cells I get the expected result, and in some I get a #NO MATCH error. I can't figure out what is wrong here. I've reviewed the data in each of the source sheets and there's nothing different about the data in each of the cells.
Any ideas?? Thanks!
Answers

Without seeing the sheet, formula, syntax, structure it would be difficult to say. Generally thought I would recommend you changing it to an index(match()) or index(Collect()). I virtually and intentionally never use VLookup.. risky, but doable if you understand the risks. Can even do an index(match(),Match()) if it's two way data.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!