Match colums from sheets [Solved/Closed]

Report
Posts
3
Registration date
Monday July 19, 2010
Status
Member
Last seen
July 20, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.



2 replies


Dear Sir,

Please have the problem solved through the below Kioskea FAQ article.

https://ccm.net/faq/

Thanks in advance.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
Looks like you would need a combination of MATCH and indirect function