Dear Experts
Sheet1 has following two columns
code--Company
--1----Philips
--2----Nokia
--3----Toshiba
--4----Motorola
--5----Sam Sung
Sheet2 has following two columns
code--Company
--1
--2
--3
--4
--5
--1
--5
--4
--2
--1
--3
In sheet2 how to fill company names against code that is exists in sheet1.
Please help
Bookmarks