Index Formula help
Hi All,
I was hoping for some feedback on this index formula I am working on. I have mapped other sheets before but this time I am getting some push back.
So I took a screenshot of the sheet. The first issue I notice is that when I try to use [Account Number]2 it errors out. This same formula works using [Account Number]@row but it does not work in the cell it needs to Center Name.
=INDEX({KO request Range 3}, MATCH([Account Number]@row, {KO request Range 5}, 0))
I am not sure what I am doing wrong. Any help would be greatly appreciated.
Answers
-
Are you getting an error or unexpected return?
-
Hey Paul! I would say both because the formula is the same in Comments column but for Center Name it shows No Match. When copied it shows Avalon which is an unexpected return.
-
Well the reason for it pulling an unexpected result for row 3 is because there is no account number.
For row 2, make sure that same exact account number is present in the {KO request Range 5} range.
If it is present, how is it populated in each of the sheets?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!