Take a look at VLOOKUP in help.

--
HTH

Bob Phillips

"Gautam" wrote in message
...
i have a sheet which contains following information

Name Last name
Address Title
City Telephone
Zip e mail
Country
of about 100nds of addresses

What i want to do in here is to get this information on another sheet
stored
in columns i.e

Name Address City Zip Country Title Telephone e-mail