How do I link one cell to a range of cell with a drop-down menu?

[Guest]

I am trying to link one series of cells to a series of cells on another
workbook or a database. I have a purchase order worksheet that has a "Product
Description" Column, "Part Number" column and a "Unit Price" column and I
would like to link these columns to a access database or table using a
drop-down menu. Please advise what is the best way to do this.

Thank You in Advance

 

[davesexcel]

For the first column you could use a drop down list using dat
validation

http://exceltips.vitalnews.com/Pages/T0960_Single-Use_Drop-Down_List.html

then the other two columns you could use vlook up

http://www.599cd.com/Free/VLOOKUP/?key=GOOGLE-VLOOKUP-BR&SRC=GOOGLE&CMP=XLSRCH&GRP=VLOOKUP&CPC=0.

 

[Guest]

Thank You