#N/A indicates that the contents of A2 weren't found anywhere in column A on
sheet2. Are you confident that that's NOT the case? Is it possible that
either the data in sheet1!A2 or the corresponding entry in column A of sheet2
has spaces before or after, or perhaps one is text and the other numeric?
Spaces and/or strings are the issue, which has the spaces and which doesn't?
Which is numeric and which isn't?

"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?