Results 1 to 9 of 9

Lookup / Indirect function to lookup information from various tabs/worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    6

    Lookup / Indirect function to lookup information from various tabs/worksheets

    First post, please help if possible.

    In the attached file, I need a formula in B2 that can:-
    1: Find a tab/worksheet that is the same name as A2.
    2: On that tab/worksheet, find the heading that is the same as B1
    3: Return the value that is in row 12 of that tab
    4: Copy the formula for the above columns and rows.

    I have left only 2 tabs in to make the file smaller. Happy to provide further information if rquired.


    Thanks,
    Raj
    Attached Files Attached Files
    Last edited by rajeshpansara; 06-18-2019 at 01:14 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Indirect and lookup across several worksheet tabs
    By flier109 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2018, 06:17 PM
  2. INDIRECT sheet references within LOOKUP function
    By PeterScho in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2016, 12:34 PM
  3. INDIRECT Function for Two-Dimensional Lookup
    By IMA_Saihat in forum Tips and Tutorials
    Replies: 3
    Last Post: 10-25-2015, 07:12 AM
  4. [SOLVED] How to use Indirect function in array lookup formula
    By PM1985 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2014, 06:58 PM
  5. Set desired record by using search function - maybe indirect or lookup
    By Lydyth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2014, 04:36 PM
  6. [SOLVED] LOOKUP function with SEARCH and INDIRECT
    By bubbacheese in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-13-2013, 03:55 PM
  7. Lookup and return information from several worksheets
    By JoeB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2005, 06:07 PM

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