View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sige
 
Posts: n/a
Default Match return #NA ...though item exists!

Hi There,

I am trying to determine the position of my item in A1 (exact match) in
a range called DBlist.
=MATCH(A1,DBList,0)

it returns #N/A but God knows why as my item definitely exists in the
DBList.

Any clues on why this could be?

Thanks for your insight,
Sige