Index Formula Using Multiple Criteria
I'm trying to create an index formula that matches two different columns in a separate sheet but I keep getting #INVALIDVALUE. What am I doing wrong?
=INDEX({02 - Pre-Con Tracker PRECON DATES}, MATCH(Comm@row, {02 - Pre-Con Tracker COMM}), MATCH(Lot@row, {02 - Pre-Con Tracker LOT NUMBER}))
Answers
-
Are you able to provide screenshots for context? How many columns does your first range cover? Are you trying to match on two separate columns or pull from two separate columns?
-
Paul,
I'm trying to match two separate columns.
I'm trying to pull the "Scheduled Date" into another sheet. But I need to match the "Comm" and "Lot" columns as well.
-
trying to add the precon date to this sheet, Paul.
-
@paulnewcome see above
-
In that case you will need an INDEX/COLLECT instead.
=INDEX(COLLECT({02 - Pre-Con Tracker PRECON DATES}, {02 - Pre-Con Tracker COMM}, Comm@row, {02 - Pre-Con Tracker LOT NUMBER}, Lot@row), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K 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!