Use the vlookup function. If your data in sheet1 begins in A2, then your
function in B2 would be =vlookup($a2,Sheet2!A:D,2,false). Copy that formula
to columns C, D, etc, changing the final 2 to a 3 in column C, 4 in column D,
and so on (if your additional information extends past column D, you'll have
to adjust the A:D so that the ending column is the final column of your
additional data). Then select all the formulas in row 2 and autofill them
into the remaining rows of your table in sheet1.

"ADiscrete1" wrote:

If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet
I have those numbers embedded with many others as well as additional
information in columns b,c,d,... =

how do I pull the data in columns b,c,d,... only associated with the phone
numbers in sheet 1?