Match colums from sheets
Solved/Closed
icicici
Posts
3
Registration date
Monday July 19, 2010
Status
Member
Last seen
July 20, 2010
-
Jul 19, 2010 at 01:25 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 20, 2010 at 07:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 20, 2010 at 07:31 AM
Hello,
I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is the same in S1 and S2) to new table.
I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is the same in S1 and S2) to new table.
Related:
- Match colums from sheets
- Music match jukebox - Download - Audio playback
- Sheet right to left google sheets - Guide
- How to move between sheets in excel - Guide
- Partial match excel - Guide
- Vba sheets add - Guide
2 responses
Dear Sir,
Please have the problem solved through the below Kioskea FAQ article.
https://ccm.net/faq/
Thanks in advance.
Please have the problem solved through the below Kioskea FAQ article.
https://ccm.net/faq/
Thanks in advance.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 20, 2010 at 07:31 AM
Jul 20, 2010 at 07:31 AM
Looks like you would need a combination of MATCH and indirect function
