Greetings,

I currently have a function I need to append to for a whole column:
=VLOOKUP(I1,'Male Tables'!AJ4:AT140,AS1)
=VLOOKUP(I2,'Male Tables'!AJ4:AT140,AS2)
=VLOOKUP(I3,'Male Tables'!AJ4:AT140,AS3)
" " " " " "

I need to append it to look like this:
=IF(I1<J1,100,VLOOKUP(I1,'Male Tables'!AJ4:AT140,AS1))
=IF(I2<J2,100,VLOOKUP(I2,'Male Tables'!AJ4:AT140,AS2))
=IF(I3<J3,100,VLOOKUP(I3,'Male Tables'!AJ4:AT140,AS3))

Is there an easy method to appended the "=IF(I1<J1,100(existing data)" to
the existing function without changing current references?

I have 6 columns with over 200 rows that I need to apply similar appends too.

Thanks for any help.
--
Just an ordinary Joe