| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Appending to existing function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| copying existing function | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
