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