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
EXCEL: Partial Cell matches in dfrnt sheets ✓ - Forum - Excel
Highlight row on one sheet if a number matches on another sheet ✓ - Forum - Excel
Add missing data before TOTAL row after matching between two sheets ✓ - Forum - Excel
Vlookup partial match from another sheet ✓ - Forum - Excel
Index match across multiple sheets ✓ - Forum - Excel

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

769
Jul 20, 2010 at 07:31 AM

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

Subscribe To Our Newsletter!