Thread: Match function won't recognize values unless I type them
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Match function won't recognize values unless I type them
Here's my standard answer for VLOOKUP(). Many of the reasons for not finding something are the same for MATCH()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bdp1978" wrote in message ...
|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?


Reply With QuoteReply With Quote