Closed Thread
Results 1 to 2 of 2

Multiple content-controlled look-ups

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Multiple content-controlled look-ups

    I need to calculate a term using 3 other content-controlled boxes. # of stories on a house (1, 1.5, 2, 3), how well-shaded (well, normal, exposed), and a climate area (1, 2, 3, 4). I know I'll be nesting statements but am unsure how to join them together without error messages. Table to pull from is below. Semi-new to excel. Thanks!

    N-values # stories
    Zone 1 1.5 2 3
    1 Well 18.6 16.7 14.9 13
    Normal 15.5 14 12.4 10.9
    Exposed 14 12.6 11.2 9.8
    2 Well 22.2 20 17.8 15.5
    Normal 18.5 16.7 14.8 13
    Exposed 16.7 15 13.3 11.7
    3 Well 25.8 23.2 20.6 18.1
    Normal 21.5 19.4 17.2 15.1
    Exposed 19.4 17.4 15.5 13.5
    4 Well 29.4 26.5 23.5 20.6
    Normal 24.5 22.1 19.6 17.2
    Exposed 22.1 19.8 17.6 15.4

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

    Re: Multiple content-controlled look-ups

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-form...-look-ups.html

    Thread Closed.
    HTH
    Regards, Jeff

Closed 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