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/