First time post and new to Excel VBA. Using win98/xl97.
I have a spreadsheet that requires a set of similar formulae. The
need to be replicated multiple times. Each formula is identical
except the logical value cell reference in the IF function i
incremented by 1 and the reference to the lookup value cells in th
VLOOKUP functions is incremented by 6. Like this:
A

=IF(sheet1!C1="R",VLOOKUP(cand!C1,reps,3,FALSE),VL OOKUP(cand!C1,dems,3,FALSE))

=IF(sheet1!C2="R",VLOOKUP(cand!C7,reps,3,FALSE),VL OOKUP(cand!C7,dems,3,FALSE))

=IF(sheet1!C3="R",VLOOKUP(cand!C13,reps,3,FALSE),V LOOKUP(cand!C13,dems,3,FALSE))

=IF(sheet1!C4="R",VLOOKUP(cand!C20,reps,3,FALSE),V LOOKUP(cand!C20,dems,3,FALSE))