Thread: Processing Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bgetson@gmail.com is offline
external usenet poster
 
Posts: 23
Default Processing Time

Does anyone know if using structured table references is better for
processing time than simple cell references?

For example, if I'm grabbing values based on:
=VLOOKUP(Equity[[#This Row],[Date/Time]],MarketData[[#Data],[Date/
Time]:[Close]],3,TRUE)-VLOOKUP(A2,MarketData[[#Data],[Date/Time]:
[Close]],3,TRUE)

is that going to be any faster than:
=VLOOKUP(A3,MarketData[[#Data],[Date/Time]:[Close]],3,TRUE)-
VLOOKUP(A2,MarketData[[#Data],[Date/Time]:[Close]],3,TRUE)

or am I just wasting my time reading/typing that all out? Keep in mind
that I have 104,000+ rows, and every second I can save counts.