Cross sheet reference,
I'm writing to you because I'm having some trouble with cross sheet reference formulas. I lost all of the formulas in my sheet, and now when I try to add a new one, it works fine for the first row, but when I drag it to another row, it says "no match." I'm sure that the formula was working fine before, but I'm not sure what's wrong with it now.
Can you please help me troubleshoot this issue? I'm really not sure what else to do.
=INDEX({stocksupplier}, MATCH(CODE@row, {stockcode}))
It works fine for First Row, the movement i drag it t apply to another row it Says "~NO MATCH
Answers
-
Try specifying an exact match in your MATCH function:
=INDEX({stocksupplier}, MATCH(CODE@row, {stockcode}, 0))
You can also look through your activity log to find the formula used and copy/paste from there.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!