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
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 responses

Blocked Profile
Jul 20, 2010 at 02:07 AM
Dear Sir,

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

https://ccm.net/faq/

Thanks in advance.
1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 20, 2010 at 07:31 AM
Looks like you would need a combination of MATCH and indirect function
0