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

[Marc]

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

[davesexcel]

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

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

[Marc]

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

Marc

"davesexcel" <[email protected]> wrote
in message news:[email protected]...
>
> check out VLOOKUP, there are lots of posts of this in your forum and in
> the many excel websites such as here:
>
> 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
>

[Tom Ogilvy]

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" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
news:[email protected]...
> Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the
far
> left column.
>
> Marc
>
> "davesexcel" <[email protected]>
wrote
> in message news:[email protected]...
> >
> > check out VLOOKUP, there are lots of posts of this in your forum and in
> > the many excel websites such as here:
> >
> > 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
> >
>
>