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.
Matt Lynn
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!