How to link data in excel?

[Chloemo]

TABLE FORM (PRICE LIST)
PAGE 1
ITEM PRICE ITEM PRICE
D000 5.00 D005 2.00
D001 6.00 D006 3.00
D002 7.00 D007 5.00
D003 2.00 D008 9.00
D004 3.00 D009 1.00
PAGE 2
ITEM PRICE
D010 7.00
D011 8.00
D012 1.00
D013 2.00
D014 3.00
D015 5.00

QUESTION
1 How can I link the original data to the table above?
2 how can the data in the table being automatically updated when I insert a new row of data in the original source?

The Original data is as follow:
ITEM Price description
D000 5.00 XXX
D001 6.00 XXX
D002 7.00 XXX

How can the table, which is the price list summary automatically updated when i insert a new row, eg D001-A, in the original data？Is it possible to do tis?

[Richard Buttrey]

First, in your Table Form create a two column list of Item & Price by cutting the column C:D data and pasting it below the last value in column A. Do the same with the data on sheet 2, pasting it to sheet 1.

Now in your original data you can use standard VLOOKUP(). e.g. Assuming the now revised table is on Sheet2

B2:
=VLOOKUP(A2,Sheet2!$A$1:$C$1000,2,False)

Copy and paste this down the whole of column B. Paste it to C2: change the ,2 to ,3 and copy and paste this to the whole of column C.

Regards