Say Column A has Phone numbers in Sheet 1 and Sheet 2 has Phone No in
Column A, Name In Column B, Address in Column C then use a vlookup

Name =VLOOKUP($A1,Sheet2!$A$1:$D$13,*2*,FALSE)
Addess =VLOOKUP($A1,Sheet2!$A$1:$D$13,*3*,FALSE)

To change lookup column just change the bol number.

Note you get a #N/A if number not in list

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=560870