+ Reply to Thread
Results 1 to 10 of 10

Search table for data in a pull down and "folklore"

  1. 11-21-2023, 11:24 AM #1
    MrO
    MrO is offline
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    Search table for data in a pull down and "folklore"

    Camping Activities (1)(2).xlsx

    I am trying to match data from a pulldown in G4 in the Activities tab, in a table in the Kingdom tab N29:X36, with the word "folklore" from H4 to folklore in n29:x36 (again in the Kingdom tab) and return the value from that chart but on cell to the right (the actual value to be added).

    I hope this makes a lick of sense. It sounds like a mouthful while writing it.


    I tried:
    =INDEX(Kingdom!$N$29:$X$36,MATCH($G$4,Kingdom!N29:$X$36,0),MATCH($F$4,Kingdom!$N$29:$X$36,0)+1) without success.
    Last edited by MrO; 11-21-2023 at 01:48 PM. Reason: Solved!
    Reply With QuoteRegister To Reply
  2. 11-21-2023, 12:04 PM #2
    AliGW
    AliGW is online now
    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. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,791

    Re: Search table for data in a pull down and "folklore"

    Are you still using Excel 2007?
    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. 11-21-2023, 12:17 PM #3
    MrO
    MrO is offline
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    Re: Search table for data in a pull down and "folklore"

    Sorry I missed adding that. Excel 2019 MSO 64-bit
    Reply With QuoteRegister To Reply
  4. 11-21-2023, 12:23 PM #4
    AliGW
    AliGW is online now
    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. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,791

    Re: Search table for data in a pull down and "folklore"

    Please update your forum profile NOW.

    Then try this:

    =LET(f,FILTER(Kingdom!$Q$29:$X$36,Kingdom!$N$29:$N$36=G4),INDEX(f,MATCH(LEFT(F4,FIND(" ",F4)-1),f,0)+1))
    Last edited by AliGW; 11-21-2023 at 12:25 PM.
    Reply With QuoteRegister To Reply
  5. 11-21-2023, 12:59 PM #5
    MrO
    MrO is offline
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    Re: Search table for data in a pull down and "folklore"

    It must be difficult keeping up with all the changes made in the various Excel versions.
    I updated my account.
    I am getting a "function isn't valid" pop-up error.
    Reply With QuoteRegister To Reply
  6. 11-21-2023, 01:02 PM #6
    AliGW
    AliGW is online now
    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. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,791

    Re: Search table for data in a pull down and "folklore"

    Provide a workbook showing the problem, please. Where is WV? Are you using a European locale?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-21-2023, 01:18 PM #7
    MrO
    MrO is offline
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    Re: Search table for data in a pull down and "folklore"

    WV is West Virginia in the southeastern part of the United States. Sorry I don't understand what you mean by workbook? Do you mean the excel file I attached?
    I will update my location with US details.
    Reply With QuoteRegister To Reply
  8. 11-21-2023, 01:38 PM #8
    AliGW
    AliGW is online now
    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. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,791

    Re: Search table for data in a pull down and "folklore"

    Have you looked at the workbook I attached? It’s your workbook with my formula working.
    Reply With QuoteRegister To Reply
  9. 11-21-2023, 01:48 PM #9
    MrO
    MrO is offline
    Registered User
    Join Date
    11-26-2012
    Location
    West Virginia, US
    MS-Off Ver
    Excel Pro Plus 2019
    Posts
    69

    Re: Search table for data in a pull down and "folklore"

    I hadn't but have now. Thank you for your help AliGW.
    Reply With QuoteRegister To Reply
  10. 11-21-2023, 01:56 PM #10
    AliGW
    AliGW is online now
    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. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,791

    Re: Search table for data in a pull down and "folklore"

    My pleasure.
    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. Based on dates in table, pull & sort data from "MASTER" page to individual month pages.
    By Natejss in forum Excel General
    Replies: 3
    Last Post: 09-22-2021, 09:20 PM
  2. Way to automatically "search" through previous entries in a single sheet and pull in data
    By TripZip in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-14-2015, 02:26 PM
  3. 7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}
    By michaelproctor001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2013, 02:13 PM
  4. Macro to "Pull Down or Up" a Table based on Pivot Table Size
    By rmmohan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 09:16 AM
  5. Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"
    By virsilens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  6. search directory for excel-files and put A136 from tab "1"-"20" in a table
    By Wim_VDW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2012, 10:33 AM
  7. How to pull info in column "C" when "A" & "B" match certain criteria
    By PowerSchoolDude in forum Excel General
    Replies: 0
    Last Post: 07-09-2009, 04:07 PM

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