I'm trying to figure out what would work best for data entry and retreval.
 

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

I'm trying to figure out what would work best for data entry and retreval.
 

check out VLOOKUP, there are lots of posts of this in your forum and in
the many excel websites such as he

http://www.contextures.com/xlFunctions02.html


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528940

I'm trying to figure out what would work best for data entry and retreval.
 

Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the far
left column.

Marc

"davesexcel" wrote
in message ...

check out VLOOKUP, there are lots of posts of this in your forum and in
the many excel websites such as he

http://www.contextures.com/xlFunctions02.html


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528940

I'm trying to figure out what would work best for data entry and retreval.
 

That is correct. If it isn't, use a combination of index and match

=Index(columnA, match(value,columnB,0),1)

as an example.

--
Regards,
Tom Ogilvy


"Marc" wrote in message
hlink.net...
Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the
far
left column.

Marc

"davesexcel"
wrote
in message ...

check out VLOOKUP, there are lots of posts of this in your forum and in
the many excel websites such as he

http://www.contextures.com/xlFunctions02.html


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=528940