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
Related:
- Compare columns in two worksheets
- Display two columns in data validation list but return only one - Guide
- Beyond compare - Download - File management
- Excel compare two sheets - Guide
- Tweetdeck larger columns - Guide
- Excel compare two columns for partial matches - 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.