+ Reply to Thread
Results 1 to 3 of 3

3 parameter table look up

  1. 11-06-2011, 05:56 PM #1
    scaponigro
    scaponigro is offline
    Registered User
    Join Date
    11-06-2011
    Location
    Florida
    MS-Off Ver
    Excel 2010 Student
    Posts
    3

    3 parameter table look up

    \1

    Can someone help me with this multiple tiered table lookup?
    I want to look up based on The Agg Size, then the Slump and then the Round or Coarse option to get the amount of water required from the table.

    Thank you!
    Reply With QuoteRegister To Reply
  2. 11-07-2011, 02:44 AM #2
    beaunydal
    beaunydal is offline
    Forum Contributor
    Join Date
    01-28-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: 3 parameter table look up

    Your problem sounds similar to this one...
    http://www.excelforum.com/excel-gene...a-vlookup.html

    Beau Nydal
    Reply With QuoteRegister To Reply
  3. 11-07-2011, 11:47 PM #3
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,748

    Re: 3 parameter table look up

    Try this, see attachment. My rows aren't exactly the same as yours so you will have to make adjustments to the formula.
    Attached Images Attached Images
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1