| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VB instead of function for INDEX
HI - I am using code to paste in this formula "=IF(ISNA(INDEX(Data,B$3,$IV8)),
"",(INDEX(Data,B$3,$IV8)))" and then copy it around the spreadsheet, but it is clumsy and has a long processing time because it is a large spreadsheet. The spreadsheet is a calendar for a list of employees performing an action so the value in B3 is a Julian Date and the value in IV is an employee number. How do you write code to behave as an INDEX function and have each cell look for the value in the range of Data? Any small example will help tremendously. Thanks in Advance Carrie I think if I can a handle on this I can also apply it to VLookups that are monsterous and solve many of my other issues as well. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200802/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT Function and INDEX Function | Excel Discussion (Misc queries) | |||
| Index Function | Excel Worksheet Functions | |||
| Index Function/Match Function | Excel Discussion (Misc queries) | |||
| Index function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
