Results 1 to 10 of 10

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

Threaded View

  1. #1
    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!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-22-2021, 09:20 PM
  2. 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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1