Results 1 to 9 of 9

Price List look-up function

Threaded View

citizenzen Price List look-up function 11-30-2012, 05:56 PM
xladept Re: Price List look-up... 11-30-2012, 06:12 PM
citizenzen Re: Price List look-up... 11-30-2012, 06:15 PM
Richard Buttrey Re: Price List look-up... 11-30-2012, 06:50 PM
xladept Re: Price List look-up... 11-30-2012, 09:17 PM
citizenzen Re: Price List look-up... 12-17-2012, 12:58 PM
xladept Re: Price List look-up... 12-17-2012, 02:59 PM
citizenzen Re: Price List look-up... 12-17-2012, 05:15 PM
Richard Buttrey Re: Price List look-up... 12-17-2012, 06:17 PM
  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    Edmonton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Price List look-up function

    Hello,

    I am not sure if I can do this without VBA; considering I have not used VBA in about a year, I'd rather exhaust my options before going back into it (as I know this might involve a lot of headaches).

    In short, I'm trying to develop a faster way to compare the price of various items. The current process first involves looking at a sheet with a list of various measurements. Each measurement is then grouped to a particular code (5, 10, etc.):

    As an example, I am looking for the price of something with measurements 1.083.

    Example of measurement list:
    Size 5S 10S 20S STD
    1" .065 0.083 .133 .25
    2" .065 .109 .155 .260


    Then, I compare the code and size to a price list to find the matching price:
    Size 5S 10S 20S STD
    1" $20 $25 $30 $40
    2" $22 $32 $42 $52

    I would like to make this a lot faster by simply typing the sizes into a cell (or over two cells) and getting the matching price --> cross referencing the paper documents is very time consuming.
    As an example, the bold/black is what I fill in; the red/itallic is what Excel pulls:
    Over 1 cell
    Size Code Price
    1.083 10S $25

    Over 2 cells
    Size Size2 Code Price
    1" .083 10S $25

    How can I do this?

    Thank you,

    Citizen
    Last edited by citizenzen; 11-30-2012 at 06:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1