Try something like this:

With
A2: Number
A3: (a number, eg: 297102 )

B1: (a date)
B2: QTY

This is a non-volatile* formula
B3: =VLOOKUP(A3,INDEX('Worksheet 1'!$3:$3,1,MATCH($B$1,'Worksheet
1'!$1:$1,0)):INDEX('Worksheet 1'!$10:$10,1,MATCH($B$1,'Worksheet
1'!$1:$1,0)+1),2,0)

This formula is volatile*
B3: =VLOOKUP(A3,OFFSET('Worksheet 1'!$A$1:$B$10,0,MATCH($B$1,'Worksheet
1'!$1:$1,0)-1),2,0)

Note_1: "Volatile" means the formula recalculates whenever the workbook
recalculates, instead of only when its referenced cells change.

Note_2: In case text wrap impacts the display, there are NO spaces in those
formulas, EXCEPT in the worksheet reference.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Johnny" wrote:

Is there a possible way LINK a (formula table array) to a cell, that when
updated it shifts that formulated array to corresponding coordinates?

WORKSHEET 1: columns A,B,C,D

9/8/2006 9/15/2006
Item Item Item Item
Number Quantity Number Quantity
300482 162 300482 162
300485 2 300485 2
490806 73225 490806 72935
490808 10309 490808 10277
490810 109835 490810 109467
490815 32042 490815 31942
494003 55129 494003 50523
496900 1785 496900 1381

WORKSHEET 2: just the FORMULA

Number QTY
297102 =VLOOKUP(A2,'WORKSHEET 1'!A$3:A$10,3,0)

LINK: with in this formula I would like to incorporate a LINK the DATE from
(WORKSHEET 1) so if I change the date within a cell on (WORKSHEET 2) to read
(9/15/06) the formula will automatically change the array from (A$3:A$10) to
(C$3:D$10)