B1: = VLOOKUP(A1,Sheet2!$A$1:$H$1000,2,False)

C1: = VLOOKUP(A1,Sheet2!$A$1:$H$1000,3,False)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"suki2shoes" wrote
in message ...

Hi

really appreciate if someone could help me

sheet1 has a list of mobile telephone numbers. ( with some details
regarding each number, name, status etc, but none of the details are
filled in)

sheet 2 has all the mobile numbers plus all the details of the people.

what i need to do is, get sheet 1 to look up the mobile number in sheet
2 and take the information (name, status etc) from sheet 2 and put in
sheet.

please help

thanks


--
suki2shoes
------------------------------------------------------------------------
suki2shoes's Profile:
http://www.excelforum.com/member.php...o&userid=25024
View this thread: http://www.excelforum.com/showthread...hreadid=399007