Or non-array entered:
=INDEX(A2:A10,MATCH(TRUE,INDEX(EXACT(B3,A2:A10),0),0))
where you are only checking that the value in B3 exists exactly as is written in B3 within A1:A10....
Or non-array entered:
=INDEX(A2:A10,MATCH(TRUE,INDEX(EXACT(B3,A2:A10),0),0))
where you are only checking that the value in B3 exists exactly as is written in B3 within A1:A10....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks