Is there a way to combine these formulas into one cell? I currently have them in 12 different cells.
=IF($I2<=Sheet1!$B$17,Sheet1!$C$17,"")
=IF(AND($I2<=Sheet1!$B$16,$I2>Sheet1!$B$17),Sheet1!$C$16,"")
=IF(AND($I2<=Sheet1!$B$15,$I2>Sheet1!$B$16),Sheet1!$C$15,"")
=IF(AND($I2<=Sheet1!$B$14,$I2>Sheet1!$B$15),Sheet1!$C$14,"")
=IF(AND($I2<=Sheet1!$B$13,$I2>Sheet1!$B$14),Sheet1!$C$13,"")
=IF(AND($I2<=Sheet1!$B$12,$I2>Sheet1!$B$13),Sheet1!$C$12,"")
=IF(AND($I2<=Sheet1!$B$11,$I2>Sheet1!$B$12),Sheet1!$C$11,"")
=IF(AND($I2<=Sheet1!$B$10,$I2>Sheet1!$B$11),Sheet1!$C$10,"")
=IF(AND($I2<=Sheet1!$B$9,$I2>Sheet1!$B$10),Sheet1!$C$9,"")
=IF(AND($I2<=Sheet1!$B$8,$I2>Sheet1!$B$9),Sheet1!$C$8,"")
=IF(AND($I2<=Sheet1!$B$7,$I2>Sheet1!$B$8),Sheet1!$C$7,"")
=IF(AND($I2<=Sheet1!$B$6,$I2>Sheet1!$B$7),Sheet1!$C$6,"")
Thanks,
Steve
Bookmarks