justtryingtolearn
New Member
- Joined
- Mar 9, 2018
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hey everybody, love this site and the helpful vibes everyone brings!
On Sheet1, I have a column of unique strings. On Sheet2, I have 7 columns of unique strings, and an 8th column with data I would like pulled into Sheet1 at the end. Each unique string from Sheet1 is buried somewhere among the 7 columns in Sheet2. I am wanting to lookup each unique string from Sheet1 in the 7 columns of Sheet2, but I am needing the search to proceed from the top row (7 cells wide) to the bottom. This is to say, starting in cell A2, the search pattern would need to go next to B2, all the way to the 7th cell, G2, before dropping down a row and starting again from A3 to G3. When a match is found, I am needing the adjacent data in Sheet2's 8th column, H, pulled adjacent to each unique string on Sheet1.
I tried using a combo of the INDEX and MATCH formulae to achieve my end here, but was unsuccessful, though since I'm a heavy VLOOKUP user and this was my first attempt using the INDEX and MATCH combo method, perhaps I'm just making a simple mistake. Below represents a dummy version of the dataset I'm working with (though it does not explain the reason why I need the search to proceed in the order I need it to proceed--which I still need).
Whether I'm just misusing the INDEX and MATCH combo, need to use another formula, or I am needing to employ some VBA here, please let me know. I am open to any of these approaches and have limited enough knowledge of VBA that I hopefully can follow along.
Thanks so much--you guys are awesome!
On Sheet1, I have a column of unique strings. On Sheet2, I have 7 columns of unique strings, and an 8th column with data I would like pulled into Sheet1 at the end. Each unique string from Sheet1 is buried somewhere among the 7 columns in Sheet2. I am wanting to lookup each unique string from Sheet1 in the 7 columns of Sheet2, but I am needing the search to proceed from the top row (7 cells wide) to the bottom. This is to say, starting in cell A2, the search pattern would need to go next to B2, all the way to the 7th cell, G2, before dropping down a row and starting again from A3 to G3. When a match is found, I am needing the adjacent data in Sheet2's 8th column, H, pulled adjacent to each unique string on Sheet1.
I tried using a combo of the INDEX and MATCH formulae to achieve my end here, but was unsuccessful, though since I'm a heavy VLOOKUP user and this was my first attempt using the INDEX and MATCH combo method, perhaps I'm just making a simple mistake. Below represents a dummy version of the dataset I'm working with (though it does not explain the reason why I need the search to proceed in the order I need it to proceed--which I still need).
Whether I'm just misusing the INDEX and MATCH combo, need to use another formula, or I am needing to employ some VBA here, please let me know. I am open to any of these approaches and have limited enough knowledge of VBA that I hopefully can follow along.
Thanks so much--you guys are awesome!