Text look up
Closed
Cai
-
Dec 17, 2011 at 11:32 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Dec 20, 2011 at 12:27 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Dec 20, 2011 at 12:27 AM
Hello,
Question is in Excel
Sheet 1 Sheet 2
A B A B
1234 Zen 1234
1356 john 1356
Q: I want to put the Data of coloum B (sheet 1) automatically in Coloum B (sheet 2) according to the the numbers of Coloum A.For Example if 1234 is Zen then in Sheet 2 it should automatically come Zen in Coloum B ...plz help
Question is in Excel
Sheet 1 Sheet 2
A B A B
1234 Zen 1234
1356 john 1356
Q: I want to put the Data of coloum B (sheet 1) automatically in Coloum B (sheet 2) according to the the numbers of Coloum A.For Example if 1234 is Zen then in Sheet 2 it should automatically come Zen in Coloum B ...plz help
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Dec 20, 2011 at 12:27 AM
Dec 20, 2011 at 12:27 AM
Use Vlookup in Column B of sheet2! as:
(Assume that first row is header)
B2 = Vlookup(A2,sheet1!A:B,2,false)
and drag the formula till end and you will get the result.
Cheers!
Rahul
(Assume that first row is header)
B2 = Vlookup(A2,sheet1!A:B,2,false)
and drag the formula till end and you will get the result.
Cheers!
Rahul