Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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.



See more

2 replies

Answer 1 / 2

Dear Sir,

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

https://ccm.net/faq/

Thanks in advance.
Thank you
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

Answer 2 / 2
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
Ask a question