+ Reply to Thread
Results 1 to 3 of 3

"ElseIf" and "Lookup" type functions on 1 Spreadsheet

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    "ElseIf" and "Lookup" type functions on 1 Spreadsheet

    Hello ExcelForum:

    I have data in a 7 column table.
    A value in G10 tells which column of that table I need to look in.
    A value in J8 tells which row of that column I need.
    I need to return the value of the 1st column of the table to J9.

    I entered the function
    =IF(G10=15,LOOKUP(J8,S2:S51,M2:M51),"n/a")
    into J9, which gives me what I want only if G10=15.

    How do I get it to give me the correct value if G10=3, 4, 5-6, 7-9, 10-12, OR 13-15?

    My sheet is attached here Density Pay.xlsx
    Thanks in advance!!

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: N00B User: Need help with "ElseIf" and "Lookup" type functions on 1 Spreadsheet

    How about this:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: "ElseIf" and "Lookup" type functions on 1 Spreadsheet

    Awesome! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining multiple functions>lookup/sum functions
    By mush106 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2013, 07:47 AM
  2. Code stepping in to elseif statement when elseif is definitely not true
    By DFrank231 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2013, 05:31 PM
  3. If Elseif elseif problem
    By tjbillund in forum Excel General
    Replies: 3
    Last Post: 08-10-2011, 07:02 AM
  4. [SOLVED] Question about lookup functions autofilling spreadsheet rows
    By Zerex71 in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 10:30 AM
  5. Replies: 0
    Last Post: 06-05-2006, 05:20 AM

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