Previous Topic Next Topic

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
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

1 response

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
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
3