Match

[rascal]

I get an excel spreadsheet daily from salesmen with a list of returns and the
original invoice number. I have the original invoices in an access database,
I have exported the list of invoices from access into an excel spreadsheet
but when i try to match the invoices from the list from the salesmen with the
list from access I never get a match. I have tried various functions(ie
match, lookup etc but nothing seems to work. I have ensured that the 2 lists
are both numbers. Any help would be most appreciated. Thanks

 

[ryguy7272]

Is that data what you think it is?
Try testing is the data is text or a number:
=ISNUMBER(A1)
This will return 'TRUE' is the data is a number

=ISTEXT(A2)
This will return 'TRUE' is the data is text

If this doesn't resolve the issue, post back with some more details of what
is going wrong; post the function that you are using, include references.

Regards,
Ryan---

 

[Marcelo]

another way

check if the data in the both lists are equal using:

=a2=c2

Excel will return TRUE if both are numbers or text and FALSE if one of then
are text of numbers

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ryguy7272" escreveu:

 

[rascal]

the numbers are stored as text in both columns when I try to convert them to
numbers they go something like this "8.82323E+13" the formula I was using to
find the match was: "=IF(C15=E1:E100,"Match","No Match")". Hopefully someone
will be able to help me figure out was is worng.