+ Reply to Thread
Results 1 to 2 of 2

Lookup value across multiple tabs and return value in another cell

Hybrid View

loulite Lookup value across multiple... 01-14-2014, 04:12 PM
mikeTRON Re: Lookup value across... 01-15-2014, 02:01 AM
  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Lookup value across multiple tabs and return value in another cell

    Hi,
    I have tried and failed to resolve the following:
    I have a spreadsheet with 31 tabs,
    30 have exactly the same structure and are named page-1, (...), page-30
    1 is a summary tab and is named "report project summary".

    In cell E7 of the summary tab, I want the following function:
    - Check in cell C7 of every tab for the value in cell C7 of the summary tab (it will be a text value)
    - If/when you find it, return the value in cell E7 of the corresponding tab (it will be a numerical value).

    Further info:
    - The value in cell C7 of the summary tab will never appear in two tabs. Once it has found it, it can stop looking

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Lookup value across multiple tabs and return value in another cell

    It might be easier to create a process to aggregate all tabs to ONE data tab then you can use a simple vlookup as you are used to.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  2. [SOLVED] 4 Way Lookup/Match - Across Multiple Tabs - Return One Value
    By skyraptor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2013, 12:38 AM
  3. Lookup multiple criteria in different tabs to return result
    By Nadir Soofi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-06-2008, 06:28 PM
  4. Using a lookup to return multiple values in one cell??
    By paul_mittoo@hotmail.com in forum Excel General
    Replies: 4
    Last Post: 07-07-2006, 08:55 AM
  5. Using a lookup to return multiple values in one cell??
    By zim_zimmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-07-2006, 08:10 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