+ Reply to Thread
Results 1 to 2 of 2

Index and Match Function Search Several Sheets

  1. 02-15-2013, 12:56 PM #1
    dosbor1
    dosbor1 is offline
    Registered User
    Join Date
    02-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Lightbulb Index and Match Function Search Several Sheets

    I am looking for a formula that will find information from a row with two unique matches that could be on one of 1 of about 50 different pages.

    The equation i am looking for applies to Cells B8:B53 on the "Brain Sheet". The equation matches data from A8:A53 from the "Brain Sheet" with data in Cells A1:A500 and could be on Sheets 1,2,3,4,5.... etc. The equation also must match data in cell $B$4 from the "Brain Sheet" with data in Cells H1:H500 from the same sheet it found the proir match. Then it pulls the information in cells J1:J500 from the sheet with matching criteria and posts the information the original cell on the "Brain Sheet". All the matched critera and information needed are in the same row. What is the equation I am looking for??
    Reply With QuoteRegister To Reply
  2. 02-16-2013, 10:11 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Index and Match Function Search Several Sheets

    '3D VLOOKUP & HYPERLINK
    Here's a page showing a formula method doing a VLOOKUP across multiple worksheets. The formula will return the answer from the first sheet that has the searched value. There's a sample file as well.


    3D VLOOKUP() and HYPERLINK()
    Last edited by JBeaucaire; 12-27-2019 at 10:23 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    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)

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