Linking 2 Sheets and Finding the Same Information
I want to link two sheets.
Sheet 1 contains multiple columns. (Column 1) Something is marked as approved. (Column 2) Contains multiple product codes/numbers. There are many rows of product codes and multiple approvals.
Sheet 2 contains multiple columns as well. (Column A) Something is marked as approved. (Column B) Contains multiple product codes/numbers. There are many rows of product codes and multiple approvals.
Essentially what I am looking looking for is if (Column 1) is marked as approved and has a certain product code (Column 2), I want it to find that same product code in Sheet 2 (Column B) and mark it as approved automatically Sheet 2 (Column A) instead of having to do it manually.
Is this possible?
Answers
-
I think you will find that Sheet 2 needs to have three "Approved" columns. One that holds the approved value from from Sheet 2, one that holds the approved value from Sheet 1, and one that is a formula which looks at both columns and records Approved if either of the two is approved. This third column will be your "official" Approved value.
Quickest way to get there is to use a VLOOKUP in sheet 2 to look for the value in sheet 1 and return the value, and OR in the third Approved column to consolidate the two columns.
-
I know this question is from a couple weeks ago and you may have use James' solution or found your own but I think an index/match formula in Column A would work also
=INDEX({Column 1}, MATCH([Column B]@row, {Column 2},0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!