Need formula help - IF/OR Array??

J

Jan

I need help writing a formula, as my attempts have not
worked.
My workbook has 4 worksheets.
I will be entering the formula on sheet4.

Basically, the following is what I need to achieve.

If any item in "List" of sheet4 column A equals the value
in sheet1!A2:A20 or sheet2!A2:A20 or sheet3!A2:A20,
return "Yes", otherwise "No".

Can anyone help me with the formula.

TIA.
 

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

Multiple sheet references in one function 0
reference every 19 rows 8
How to check a condition and write another cell 0
Need Help with a VBA subroutine 0
Indirect used in an array formula 3
Search an array of sheets for an array of numbers & return count of numbers 11
Help with lots of formulas 3
Array formula lock-up 1

Top