| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function won't recognize values unless I type them
I am using the match function to identify values that appear in two separate
lists. However, the function will not recognize values in the second list even though they are clearly there. If I then re-type the value in the second list (there were originally copied and pasted from a web page) the match function works correctly. Any ideas or ways to fix this without re-typing all values? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Match type? | Excel Discussion (Misc queries) | |||
| My Excel does not recognize countif function | Excel Worksheet Functions | |||
| IF Function doesn't recognize TRUE | Excel Worksheet Functions | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Threaded Mode
