Hi Carrie

Show us the code you are using now, maybe it can be speeded up a bit.

Regards,

Per

On 3 Feb., 03:03, "Carrie_Loos via OfficeKB.com" <u34134@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200802/1