+ Reply to Thread
Results 1 to 6 of 6

How can I use VLOOKUP to search within a table contains 4 variables

Hybrid View

  1. #1
    Registered User
    Join Date
    05-12-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2003, 2007, 2010 and 2013
    Posts
    56

    How can I use VLOOKUP to search within a table contains 4 variables

    How can I use VLOOKUP to search within a table contains 4 variables?
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,028

    Re: How can I use VLOOKUP to search within a table contains 4 variables

    Try INDEX/MATCH combination
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    05-12-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2003, 2007, 2010 and 2013
    Posts
    56

    Re: How can I use VLOOKUP to search within a table contains 4 variables

    how can use INDEX/MATCH combination

  4. #4
    Registered User
    Join Date
    06-20-2013
    Location
    Northern CA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How can I use VLOOKUP to search within a table contains 4 variables

    Medo, There's always more than one way. I offer one: In the attachment, I created a key table. If you like this option, you will need to complete it, as I only created it for one quadrant; but, you can copy and then find+replace Factor 1 and update the Multiplier reference. I inserted the multiplier as a formula, so that you can keep your original table up-to-date, and the update would transfer to the key. The unique identifier is a formula that just needs to be dragged or copied down as you extend the key.

    I'm not sure how you referred to the value in the table (i.e.: .76), but I called it "multiplier". Also, I don't fully understand how you might use or want to extract the multiplier, but I offered a solution in two rows called Entry Points (rows 31 & 32). You enter the factor information, and the multiplier is looked up in the Key. Hope this helps. Tankstir
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-12-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2003, 2007, 2010 and 2013
    Posts
    56

    Re: How can I use VLOOKUP to search within a table contains 4 variables

    Tankstir,
    You are very intelligent
    Thanks to the speed of reply
    This method has been successful
    Thank you very much

  6. #6
    Registered User
    Join Date
    06-20-2013
    Location
    Northern CA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How can I use VLOOKUP to search within a table contains 4 variables

    Glad to help you on the other side of the world. Please change your post to "Solved". regards

+ 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