I have three cells that must meet different criteria in 3 differen
cells in order to populate the target cell with a text value.. Th
range of the sheet is large and I don't want to bog it down wit
formulas. Is there another way to do it other than using If or And as
formula

example =And(A10 = "Abc",X2 = "Y",Z2 10)
then loop to the next cell in range A1:AA250

Thank

--
Message posted from http://www.ExcelForum.com

Hi
though this could be done with a macro formulas are usually much faster
than using VBA. So I'd use the formulas you already have in place

--
Regards
Frank Kabel
Frankfurt, Germany

"hotherps " schrieb im
Newsbeitrag ...
I have three cells that must meet different criteria in 3 different
cells in order to populate the target cell with a text value.. The
range of the sheet is large and I don't want to bog it down with
formulas. Is there another way to do it other than using If or And as
a
formula

example =And(A10 = "Abc",X2 = "Y",Z2 10)
then loop to the next cell in range A1:AA250

Thanks


---
Message posted from http://www.ExcelForum.com/

Ok Frank, thanks for your response. One more question what if th
variables for my formula change as the code loops through the range
Let me be more specific.

I'm trying to assign tasks to people that are working on a shift. Th
need for tasks is calculated in hours. So I want to be able to assig
someone to a task by adding a short text value to a cell in thei
shift, so they can see what task they are assigned to for tha
interval, usually in groups of 4 cells at a time.

So the task must have a value greater than 0, the need must be withi
the employee's shift, and the employee must be trained in the task.

So for each cell in the loop range these 3 three conditions have to b
checked for. If any one of the three can not be met, the code shoul
check for the next task, and so on.

I'm not sure how I would have the formula change to check for th
other tasks as they are needed.

Does that make sense? Is there a way to have the code check all thre
parameters before populating the cell?

Thanks again for your repl

--
Message posted from http://www.ExcelForum.com