Compare sheet and return last column
Closed
mewlz
-
Nov 2, 2011 at 01:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 3, 2011 at 02:08 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 3, 2011 at 02:08 AM
Related:
- Compare sheet and return last column
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Flipkart return comments - Guide
- Beyond compare - Download - File management
- Display two columns in data validation list but return only one - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 3, 2011 at 02:08 AM
Nov 3, 2011 at 02:08 AM
sheet1 is like this
First name Surname Father's name
a q t
s w y
d e u
f r i
in D1 type "mother's name" (without quotes)
sheet 2 is like this
First name Surname Mother's name
a q z
s w x
d e c
f r v
in sheet 1 in D2 copy this formula
=INDEX(Sheet2!$C$2:$C$100,MATCH(1,((Sheet2!$A$2:$A$100=Sheet1!A2)*(Sheet2!$B$2:$B$100=Sheet1!B2)),0))
INVOKE THIS FORMULA BY CONTROL SHIFT ENTER
copy D2 down
this will be ok for about 100 rows of data.
First name Surname Father's name
a q t
s w y
d e u
f r i
in D1 type "mother's name" (without quotes)
sheet 2 is like this
First name Surname Mother's name
a q z
s w x
d e c
f r v
in sheet 1 in D2 copy this formula
=INDEX(Sheet2!$C$2:$C$100,MATCH(1,((Sheet2!$A$2:$A$100=Sheet1!A2)*(Sheet2!$B$2:$B$100=Sheet1!B2)),0))
INVOKE THIS FORMULA BY CONTROL SHIFT ENTER
copy D2 down
this will be ok for about 100 rows of data.
