Hi all, im looking for a way of using named cells instead of nesting IF functions, im going to work with 2 BIG IF functions, in the case im working out I can use a VLOOKUP function but I need it for instructional purposes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
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>
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>