=IF(I1<J1,100,VLOOKUP(I1,'Male Tables'!$AJ$4:$AT$140,AS1))

Just copy down as far as you need. All references will be adjusted, with the exception those with $ signs.

BTW, I can't imagine the "AS1" is correct. Shouldn't it just be 10; the relative column number in the search table?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"D.Jessup" wrote in message ...
| 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