using a table in a sheet like database table and use it in other sheets

[mccbul]

Hi there,

I want to create several tables in a sheet (i.e. : sheet A) and use these lists in other sheets.

For example :
Attachment 262123
the image above shows my lists column by column. First columns shows the lists and second is the products table that I added all products and define the properties. These definition and lookup tables will be constant.

And the last table is the main list that user will be able to create a bid.

I can create lists and let user to select from comboboxes (or dropdownlists) but I don't know how to let user to select any product from combobox and get the selected item's other columns.

I hope i could tell my problem with my poor english.

Thanks in advance.

[JBeaucaire]

TIP: Upload a workbook instead of a picture of one, we can test our ideas instantly that way.

USD should not be "text" in the G13:H16, make sure thats number formatting. Only numbers should be IN those cells.

VLOOKUP looks usable in this sample.

G21: =VLOOKUP(B21, $B$13:$G$16, 6, 0) * D21 * (1+F21)