Previous Topic Next Topic

Match colums from sheets

Solved/Closed
icicici Posts 3 Registration date Monday 19 July 2010 Status Member Last seen 20 July 2010 - 19 Jul 2010 à 13:25
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Jul 2010 à 07:31
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.



Related:

2 responses

Réponse 1 / 2
Blocked Profile
20 Jul 2010 à 02:07
Dear Sir,

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

https://ccm.net/faq/

Thanks in advance.
Réponse 2 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Jul 2010 à 07:31
Looks like you would need a combination of MATCH and indirect function

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses