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
|