+ Reply to Thread
Results 1 to 4 of 4

Multiple results from one list

Hybrid View

~TaC~ Multiple results from one list 09-09-2018, 03:49 AM
AliGW Re: Multiple results from one... 09-09-2018, 03:56 AM
kvsrinivasamurthy Re: Multiple results from one... 09-09-2018, 10:15 AM
~TaC~ Re: Multiple results from one... 09-10-2018, 12:22 PM
  1. 09-09-2018, 03:49 AM #1
    ~TaC~ is offline
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    Multiple results from one list

    Hi,

    I am putting together a holiday tracker where I am incorporating a calculator to roughly equate what holiday employees have.

    The example attached seems to work so far but what I am looking for is formulas for D23, E23 & G23 so when the name is selected in B23 it pulls the relevant data from sheet 2 that corresponds to the name selected.

    The reason I am here is because my knowledge only goes as far as using the IF statement and I am sure only 7 of these can be in one formula and I am sure there must be an easier way.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-09-2018, 03:56 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,387

    Re: Multiple results from one list

    7 was in older versions - I think its now something like 56. However, multiple nested IFs are rarely needed if you set up lookup tables:

    =IF(VLOOKUP(B23,Sheet2!$C$7:$E$28,3,0)="","",VLOOKUP(B23,Sheet2!$C$7:$E$28,3,0))
    Last edited by AliGW; 09-09-2018 at 04:00 AM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 09-09-2018, 10:15 AM #3
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Multiple results from one list

    In D23 then copied to other cells.

    =IF(VLOOKUP($B23,Sheet2!$C$7:$F$28,MATCH(D$22,Sheet2!$D$6:$F$6,0)+1,0)="","",VLOOKUP($B23,Sheet2!$C$7:$F$28,MATCH(D$22,Sheet2!$D$6:$F$6,0)+1,0))
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 09-09-2018 at 10:25 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 09-10-2018, 12:22 PM #4
    ~TaC~ is offline
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    Re: Multiple results from one list

    Works perfectly thanks.

    But just so I am able to work this out in future, what do the numbers after the sheet2 cell reference refer to.

    In the first reply ,3,0 after $E$28
    In second reply ,0)+1,0)
    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)

Similar Threads

  1. Multiple drop-down list selections and HLOOKUP multiple results in the same cell
    By Daervon in forum Excel General
    Replies: 10
    Last Post: 08-12-2017, 09:57 AM
  2. List Top Ten Items - Multiple Criteria Lookup With Multiple Results - Sorted Descending
    By Whizbang in forum Excel General
    Replies: 1
    Last Post: 09-04-2014, 12:14 PM
  3. Multiple Search Criteria produces (list) Multiple results in a single cell
    By snake007uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2014, 12:13 PM
  4. Drop Down List to return multiple results in multiple cells
    By Joshua27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 11:50 AM
  5. Find multiple values in multiple ranges and produce results in a list
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 02:11 AM
  6. Extracting multiple results populated from changing dropdown list to compare results
    By XLamature in forum Excel General
    Replies: 3
    Last Post: 10-30-2013, 09:18 AM
  7. Search multiple sheets and return list of multiple results
    By Abuck in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-07-2012, 11:59 AM

Tags for this Thread

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