On one work sheet I would have my vendor and product categories both of
these would be referenced to numbers.

Column1(vendors) Column2(product categories)
Acme would equal 1 Widgets would equal 1

One the second worksheet I would have the first 2 columns would be
referenced to the numeric value of the other worksheet (trying to save on
size) the balance of the columns would be model number, description, pieces
per package, cost, sell, msrp, date entered, date edited.


Column1(vendors) Column2(product categories) Column3(model number)
Column4(description) Column5(cost) Column6(sell) Column7(date entered)
1 1



Column8(date edited)

To enter the data the form would have 2 combo boxes that would be from
column 1 and 3 on the first worksheet but would enter the integer value in
columns one and two of the second worksheet. The balance would be text
boxes.

To look up data I would like to be able to use any of the of these columns -
vendor, product category, model number and description to input the
information into a quote sheet.

Is this doable in Excel? I have tried several of the quote software that's
available and nothing covers everything I need.

Marc