INDEX MATCH MATCH to OTHER WORKSHEET
Hi,
I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets.
How do I reference the columns as a range and a value?
The formula should be as follows:
(in cell B2) =INDEX(Sheet1!,MATCH($A2,Sheet1!$A:$A,0),MATCH(B$2,Sheet1!$B:$B,0))
An INDEX(MATCH) or VLOOKUP for each individual column is not an acceptable answer as there are tens and tens of columns :)
Thanks!
Answers
-
You would need to have a helper row in your data sheet that contains the column names. Then you would use something along the lines of...
=INDEX({Range to pull from}, MATCH([Column A]@row, {Other Sheet Column A}, 0), MATCH([Column B]@row, {Other Sheet Helper Row}, 0))
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