vlookup and sort error
Thank you for reading...
I am having an issue with sorting by numbers:
example of issue:
58849864
55465978
54668976
54668978
54668979
55465977
55465979
For some reason it will not sort ascending correctly. Would anybody have any
ideas as to what I should try or what the issue is?
vlookup:
The issue I am having with vlookup is that I believe my formulas are all
correct and I have the data I want to refer to on the left most column.
example:
A B
1 52334231 =vlookup(A1,Customers,2,0)
I have Customers defined but all I get in B1 is N/A.
Customers looks like this:
A B
1 52334231 1122 WhereDidIGo Rd.
Any suggestions, ideas, or answers is greatly appreciated.
Thank you.
|