| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doe this match nor work?
Check out the attachment. Why does the match formula not work( for product 777)? The columns Exception and code are both formatted as text because of the zero. I need them to stay formatted as text. Any ideas Chris +-------------------------------------------------------------------+ |Filename: Sample.zip | |Download: http://www.excelforum.com/attachment.php?postid=4541 | +-------------------------------------------------------------------+ -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=527547 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doe this match nor work?
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 -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=527547 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doe this match nor work?
if you overtype 777 with '777 ie force it in as text, it does work. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=527547 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Index | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Hybrid Mode
