Hi - can anyone tell me why I get #NA when I try to match a cell with contents:
AWDAXJ$(RI#S)~£
with another cell with exactly the same entry?
And is there a workaround?
Thanks

The tilde is causing the problem. I'm guessing because its a type of wildcard
character.

Possible workarounds: Depending on what your doing, maybe using FIND,
LOOKUP, or VLOOKUP?

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Smallweed" wrote:

Hi - can anyone tell me why I get #NA when I try to match a cell with contents:
AWDAXJ$(RI#S)~£
with another cell with exactly the same entry?
And is there a workaround?
Thanks

would you post your formula?


--
Appreciate that you click on the Yes button below if this posting is helpful.

Thank You

cheers, francis


"Smallweed" wrote:

Hi - can anyone tell me why I get #NA when I try to match a cell with contents:
AWDAXJ$(RI#S)~£
with another cell with exactly the same entry?
And is there a workaround?
Thanks

The tilde ~ character is a special control character. To use it
literally, use two. For example,

=MATCH("AWDAXJ$(RI#S)~~£",G1:G10,0)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Fri, 9 Jan 2009 05:13:01 -0800, Smallweed
wrote:

Hi - can anyone tell me why I get #NA when I try to match a cell with contents:
AWDAXJ$(RI#S)~£
with another cell with exactly the same entry?
And is there a workaround?
Thanks