# formula question

Posted by Celeste on January 14, 2002 3:58 PM

i have a column that has a pretty long IF formula in it. my formula reads as follows:

=IF(ISNUMBER(MATCH(T78,MDPRODUCTCODE,0)),(VLOOKUP(T78,MDPRODUCTMARKUP,4,0)),"ZZZ")

what i need to do, is change the "ZZZ" portion of the formula to say ,R78 (equal cell R78). here's my dilemma, i have a column of over 1000 lines of this formula in it. i want the formula to equal column R of the corresponding line. i'm wondering if there is a way, using the find/replace feature, that i can say to find "ZZZ" and replace it with the value in R on the corresponding line. i've done this before (many moons ago) on another spreadsheet program and was able to put in there some kind of little formula (i think it had an anstrick) so i wouldn't have to change each individual formula. filling down is not an option because there are many breaks and borders that would take even more time to put back.

any and all help would be appreciated