No it wouldn't. The fnd is a little more forgiving. Best way to check for
spaces is to select the cell and click in the formula bar. If you go to the
very beginning of the 'formula', is there a space before the number? If you
go the very end, is there a space after?
As for whether a 'number' really is a number or just a string representation
of a number, click in the cell and apply the comma style. Did you get two
decimal points? Yes implies a number, no implies a string.
Check for both issues both on Sheet1!A2 and the matching cell on Sheet2.

"ADiscrete1" wrote:

when I cut and pasted and asked it to find it found it; wouldn't that denote
all was in order with format?

"bpeltzer" wrote:

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