or(exact)) function does not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!

I am trying to compare a list of words to an array of words.

so example:
john to great
dog
john

To do this I am using the function
=or(exact(A1, B1:B3))

As told to do by help... but this does not work if the word you are
searching for is not the first cell in the array.....

Please help on why this is.....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Altered pasting functionality 3
Search function in Excel 5
EXACT function - but where does it not match? 8
Simple custom function 3
Find an exact word in a cell with many words 12
Excel VBA help: Text file formatting 19
Array Formula/UDF 3
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4

Back
Top