INDEX/MATCH Function Trouble
Hi Community, I am not the best with formulas and having trouble.
I have a Master Data sheet that has all my information about what each chemistry needs to be tested.
I have my new sheet, where I want to be able to enter in my chemistry, then the sheet will pull information from the Master Sheet and fill it in, according to whatever chemistry has been entered in that first cell.
Here is a clip from my New Sheet, where I would want "Cal Kit" to be filled in automatically whenever I enter in a new chemistry.
And here is a clip from my Master Data. The "Cal Kit" column is the information I am trying to get pulled over, depending on my chemistry of course.
Every time I try that formula, I am getting a circular reference error. How do I get it to index the Cal Kit column in relation to the chem. So when I enter in a Chem it pulls what cal kit(s) are used. Would it be easier to index the cal kit column in relation to the part number?
I know this is a bit confusing and hard to describe, I am trying my best to make it as clear as possible! Thanks for any suggestions!
Answers
-
Would it be easier to reference part number instead of cal kit number: yes
by the looks of it, it looks like the [cal kit]@row column you are trying to match is blank. I recommend replacing it like this, assuming your Part Number@row is not blank:
=INDEX({Master Cal Kit}, MATCH([Part Number]@row, {Part Number Column}, 0))
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 409 Global Discussions
- 219 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!