M
Melvin Soh
Dear Public,
I seem to be having a match and exact function problem.
2 worksheets
each with values that are identical but spaced and sorted differently.
Case 1:
i tried matching two exact values on the different worksheets but was
unable to come up with a "TRUE" result.
=exact(a1,'workbookname'!a10)=FALSE
where a1 = 117-113
and
'workbookname'!a10 = 117-113
all values have been cleaned etc. i might not have specified the work
booklinking correctly here but i assure you its correctly programmed
in the worksheet(i pointed and clicked).
the values for the 2 worksheets were obtained from different sources.
when i tried hardcoding a1 again (to value 117-113) then it works.
However, this is too time consuming to do for all cells. I think this
might be a problem with the underlying languages used to program the
workbooks (difference between english, chinese etc.). How can two
identical values give a FALSE exact result?
Case 2:
Same workbooks again.
When i tried matching
165/165-2~165-22/165-25/165-26/165-35~165-75/165-83/168-4/168-8/168-119共69筆
to
165/165-2~165-22/165-25/165-26/165-35~165-75/165-83/168-4/168-8/168-119共69筆
it returns a #N/A value. Again i assure you the function was properly
programmed. Match sporadically returns the correct match value while
for other cells returns a #N/A value even if the cells contained
simpler data. Again why does excel not match two identical
text/values?
I've cleaned all cells but to no avail.
Please help...
Thank you for your time in advance.
Sincerely,
M.Soh
I seem to be having a match and exact function problem.
2 worksheets
each with values that are identical but spaced and sorted differently.
Case 1:
i tried matching two exact values on the different worksheets but was
unable to come up with a "TRUE" result.
=exact(a1,'workbookname'!a10)=FALSE
where a1 = 117-113
and
'workbookname'!a10 = 117-113
all values have been cleaned etc. i might not have specified the work
booklinking correctly here but i assure you its correctly programmed
in the worksheet(i pointed and clicked).
the values for the 2 worksheets were obtained from different sources.
when i tried hardcoding a1 again (to value 117-113) then it works.
However, this is too time consuming to do for all cells. I think this
might be a problem with the underlying languages used to program the
workbooks (difference between english, chinese etc.). How can two
identical values give a FALSE exact result?
Case 2:
Same workbooks again.
When i tried matching
165/165-2~165-22/165-25/165-26/165-35~165-75/165-83/168-4/168-8/168-119共69筆
to
165/165-2~165-22/165-25/165-26/165-35~165-75/165-83/168-4/168-8/168-119共69筆
it returns a #N/A value. Again i assure you the function was properly
programmed. Match sporadically returns the correct match value while
for other cells returns a #N/A value even if the cells contained
simpler data. Again why does excel not match two identical
text/values?
I've cleaned all cells but to no avail.
Please help...
Thank you for your time in advance.
Sincerely,
M.Soh