formula issue

[Moggie]

Hi all,

I have been using the following formula to compare lists:

{=or(exact(a2,all))}

In most cases it looks for the value in the cell reference
and returns true if it appears in the named range. Except
in one instance. There is a single value that says it is
not found, although I can clearly find it. I've checked
formats and can't find anything.

Any suggestions as to what's going on?

Thanks for your help,
moggie

 

[Frank Kabel]

Hi
have you tried a manual comparison with something like
=A2=cell_in_your_range

Does this return TRUE for the specific value?

 

[moggie]

Thanks for your help Frank. This problem is driving me mad.

I've tried that out and it still doesn't recognise that
it's the same value. Here is a sample of the type of value
I am cross-checking 6121602-23010. Could it be the '-'?

I tried doing a find on the value in both lists to test
the number but the find worked perfectly. I can't figure
out what I am missing.

Moggie

 

[Frank Kabel]

Hi
if you like email me your file, indicate the specific value and I'll
have a look at it:
email: frank[dot]kabel[at]freenet[dot]de

 

[Guest]

Hi Frank,

I've just sent it from my hotmail account. It will be from
morag[underscore]mcintosh[at]hotmail[dot]com.

Thanks so much,
Morag

-----Original Message-----
Hi
if you like email me your file, indicate the specific value and I'll
have a look at it:
email: frank[dot]kabel[at]freenet[dot]de


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks for your help Frank. This problem is driving me mad.

I've tried that out and it still doesn't recognise that
it's the same value. Here is a sample of the type of value
I am cross-checking 6121602-23010. Could it be the '-'?

I tried doing a find on the value in both lists to test
the number but the find worked perfectly. I can't figure
out what I am missing.

Moggie
im
Newsbeitrag

.

 

[Frank Kabel]

Hi
just as a follow up: the reason for the error was a trailing space in
the master sheet. So the values weren't identical

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank,

I've just sent it from my hotmail account. It will be from
morag[underscore]mcintosh[at]hotmail[dot]com.

Thanks so much,
Morag

-----Original Message-----
Hi
if you like email me your file, indicate the specific value and I'll
have a look at it:
email: frank[dot]kabel[at]freenet[dot]de


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks for your help Frank. This problem is driving me mad.

I've tried that out and it still doesn't recognise that
it's the same value. Here is a sample of the type of value
I am cross-checking 6121602-23010. Could it be the '-'?

I tried doing a find on the value in both lists to test
the number but the find worked perfectly. I can't figure
out what I am missing.

Moggie

-----Original Message-----
Hi
have you tried a manual comparison with something like
=A2=cell_in_your_range

Does this return TRUE for the specific value?


--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag
Hi all,

I have been using the following formula to compare
lists:

{=or(exact(a2,all))}

In most cases it looks for the value in the cell
reference
and returns true if it appears in the named range.
Except
in one instance. There is a single value that says it is
not found, although I can clearly find it. I've checked
formats and can't find anything.

Any suggestions as to what's going on?

Thanks for your help,
moggie

.

.