+ Reply to Thread
Results 1 to 2 of 2

Need help on Lookup the tabe code

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    SLD
    MS-Off Ver
    Excel 2010
    Posts
    73

    Need help on Lookup the tabe code

    Can anyone help me on this

    I have a table of "Rate Reference" on Sheet TableOfRef which depend on Type of Product and Color of product.

    On other sheet (Sheet2) I have inputs of (Product / Color / Qty). Now I need the rate based on these inputs and the Table of Reference.


    Example: I have (Product 9 / Blue / 10,000)

    I check the table of Ref for that Product and Color and have the: "Qty/2500+100" So the rate would be: 10,000/2500+100 = 104

    How can I formular cell E3?

    See the attach

    Thank a lot!!!
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need help on Lookup the tabe code

    IMO you would make this so much easier if you could expand the table. Is this possible as a solution for you?
    Attached Files Attached Files
    Last edited by jeffreybrown; 01-17-2012 at 09:58 PM.
    HTH
    Regards, Jeff

+ Reply to Thread

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