Compare two columns in different sheet and retrive corrspo value
Closed
gbssraju
Posts
1
Registration date
Thursday March 14, 2013
Status
Member
Last seen
March 14, 2013
-
Mar 14, 2013 at 05:37 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 14, 2013 at 04:39 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 14, 2013 at 04:39 PM
Related:
- Compare two columns in different sheet and retrive corrspo value
- Mark sheet in excel - Guide
- Sheet right to left in google sheet - Guide
- Display two columns in data validation list but return only one - Guide
- Beyond compare - Download - File management
- Little alchemy cheat sheet - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 14, 2013 at 04:39 PM
Mar 14, 2013 at 04:39 PM
Hi gbssraju,
Please use following formulas in Cells C1 through C4 of the Sheet 1:
=VLOOKUP(A1,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A2,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A3,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A4,Sheet2!$A$1:$C$4,3,0)
Do reply with results.
Please use following formulas in Cells C1 through C4 of the Sheet 1:
=VLOOKUP(A1,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A2,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A3,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A4,Sheet2!$A$1:$C$4,3,0)
Do reply with results.