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 4479 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.

Match colums from sheets
How to copy data from one sheet to another in excel automatically - Guide
Google sheets change sheet direction - Guide
Music match jukebox - Download - Audio playback
Excel match two columns and output third ✓ - Excel Forum

2 replies

Answer 1 / 2

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.

Answer 2 / 2

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jul 20, 2010 at 07:31 AM

Looks like you would need a combination of MATCH and indirect function

Similar discussions

Modern Warfare 2 online cant find matchs why

Facebook says that my email doesn't match my facebook email

Facebook account not match

Compare values in two columns and return the value from third

Email doesn't match with any account

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!