Why doe this match nor work?

C

cj21

Check out the attachment. Why does the match formula not work( fo
product 777)? The columns Exception and code are both formatted as tex
because of the zero. I need them to stay formatted as text.

Any ideas

Chri

+-------------------------------------------------------------------
|Filename: Sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=4541
+-------------------------------------------------------------------
 
G

Gary Brown

Because Excel thinks that the 777 in A9 is a number whereas the table
which has 777 in cell E5 thinks its text.

Excel is therfore getting confused, I would guess that you have copied
and pasted the 777 in cell A9 from somewhere else.

To prove the point if you edit the value in A9, by selecting the cell
and pressing F2, then enter, I think you will find that Excel
re-interprets the cell according to its format (text) and puts the
correct value in C9

G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top