populating a cell based on another range of cells in excel

G

Guest

I want to populate a cell based on a 'x' in another cell. I am using two
worksheets in my excel file. One that a individual will fill out and one that
will tell if the form needs approval. This is the formula I have in a cell on
the Approval Worksheet.

=IF('MercyInsightAccessRequest Form'!I6:I100="x","Approval Needed From
Maureen Castulik","No Approval Needed")

This works fine, but I want to check a cell range for a 'x' not just I6. I
want the Approval worksheet to state "Approval Needed From Maureen Castulik"
If there is a 'x' anywhere in I6 through say I100. Using the formula below
does not work.

=IF('MercyInsightAccessRequest Form'!I6:I100="x","Approval Needed From
Maureen Castulik","No Approval Needed")

I also would like to check multiple columns the same way. If say J6 through
M6 has a 'x' I want the Approval worksheet to say "Approval Needed From Linda
Weindel". This should also check down about 100 rows, it should check
J6:J100, K6:K100, L6:L100, and M6:M100. If there is a 'x' in any of these
rows I want the Approval worksheet to state "Approval Needed From Linda
Weindel".

I realize this can be done with a Macro and the Visual Basic Editor, but I
would rather not. I hope someone can understand what I am wanting to do.
Please help.
 

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

Conditional Formatting Based on Date 1
Outlook 2013 VBA extract subject and body to blank worksheet 0
Formula to extract data from other worksheet 3
Is there an Excel Function that can be used in lieu of this formul 5
Saving to a worksheet in another file...? 3
Cell doesn't change if another cell is Y, otherwise make it = a thirdcell 2
Creating formulas 1
Help with email workbook 4

Top