So here’s what I’ll do, I’ll take this first function and give it a name, let’s say formula_1<o></o>

=IF(C2=$A$13,$B$13,IF(C2=$A$14,$B$14,IF(C2=$A$15,$B$15,IF(C2=$A$16,$B$16,IF(C2=$A$17,$B$17,IF(C2=$A$18,$B$18,IF(C2=$A$19,$B$19,0)))))))<o></o>

This second one, formula_2<o></o>

=IF(C2=$A$20,$B$20,IF(C2=$A$21,$B$21,IF(C2>=$A$22,$B$22,0)))<o></o>

And ill do this =if(formula_1,formula_1, formula_2)<o></o>

So here’s the Q, when I place this function on the first group of values A2 to evaluate everything is ok, but how do I copy it down the cells to evaluate the other group of data, B, C,etc.<o></o>