Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Chicago, Illinois, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Order Form/Catalog Page (Excel 2002)

    I would like to create a 2 sheet workbook - sheet 1 would be a blank Order Form and sheet 2 would be a Catalog Page of 100 items numbers with prices. On the sheet 1 Order Form, I would like to type any item number (from sheet 2) in column one and have the price (from sheet 2) automatically appear in column two. Thanks in advance for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order Form/Catalog Page (Excel 2002)

    Say that the catalog on Sheet2 is in A2:B101 (row 1 contains headers).
    Say that the item numbers on Sheet1 will be filled in starting in A2. In B2, enter this formula:
    <code>
    =IF(A2="","",VLOOKUP(A2,'Sheet2'!$A$2:$B$101,2,FAL SE))
    </code>
    Replace Sheet2 with the actual name of the sheet and fill down as far as needed.

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Order Form/Catalog Page (Excel 2002)

    MVP John Walkenbach set a challenge to create a simple invoice app. You can download the 9 workbooks from those that took up the challenge from Invoice App: The Results.

    These workbooks may help you develop your workbook and show how others have approached a similar issue.

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order Form/Catalog Page (Excel 2002)

    Thanks Tony. Great find... since I just happen to be looking for ideas in developing just such a beast for one of our clients! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Alan

  5. #5
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Order Form/Catalog Page (Excel 2002)

    GREAT Tony and thanks a couple of these are almost perfect in what I am looking for. Now I just have to decide which of these comes closest to my need, and mess with it a little bit.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  6. #6
    New Lounger
    Join Date
    Jul 2004
    Location
    Chicago, Illinois, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order Form/Catalog Page (Excel 2002)

    Hans provided exactly what I needed but reviewing the other invoices was super. Special thanks to all for your generosity and your superior intelligence.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •