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