View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bdp1978 bdp1978 is offline
external usenet poster
 
Posts: 2
Default 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?