Compare columns in two worksheets
Closed
NV
-
Nov 17, 2010 at 04:03 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 18, 2010 at 07:59 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 18, 2010 at 07:59 PM
Hello,
I have two worksheets within one Excel workbook, in which I need to compare Column G in worksheet 1 to Column G in worksheet 2, then if they match, return values from Column I, already entered into worksheet 1, to Column I in worksheet 2.
Can anyone supply me with a formula to do so?
Thank you.
I have two worksheets within one Excel workbook, in which I need to compare Column G in worksheet 1 to Column G in worksheet 2, then if they match, return values from Column I, already entered into worksheet 1, to Column I in worksheet 2.
Can anyone supply me with a formula to do so?
Thank you.
Related:
- Compare columns in two worksheets
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
- How to delete columns in word - Guide
- Excel compare two sheets - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 17, 2010 at 09:03 PM
Nov 17, 2010 at 09:03 PM
in sheet 2 in A1 type this formula
copy A1 in sheet 2 down as long as data is there in column G in the same sheet.
post feedback whether you got what you want.
=INDEX(Sheet1!$A$1:$A$6,MATCH(Sheet2!G1,Sheet1!$G$1:$G$6,0),1)
copy A1 in sheet 2 down as long as data is there in column G in the same sheet.
post feedback whether you got what you want.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 18, 2010 at 07:59 PM
Nov 18, 2010 at 07:59 PM
quote
return values from Column I,
unquote
sorry I misunderstood I(for India) as 1(one) . so substitute A by I in the formula and see whether you get what you want.
return values from Column I,
unquote
sorry I misunderstood I(for India) as 1(one) . so substitute A by I in the formula and see whether you get what you want.
=INDEX(Sheet1!$I$1:$I$6,MATCH(Sheet2!G1,Sheet1!$G$1:$G$6,0),1)
Nov 18, 2010 at 09:17 AM
Not sure where Column A would need to come into play. I received #N/A when I tried the above formula.
I have multiple rows of information in Column G of both worksheets (which need to be compared), and the information I need transposed (if the previous mathces) to Column I of the second sheet, is listed in Column I of the first sheet. Does this explanation help?
Additional help is greatly appreciated!
Thank you.