+ Reply to Thread
Results 1 to 3 of 3

Find matching header between two tables and returning that column's specific row value.

  1. #1
    Registered User
    Join Date
    05-18-2016
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    8

    Find matching header between two tables and returning that column's specific row value.

    Hello,

    I could really use some help trying to figure out the right formula to use in the following scenario:

    I have two tables. One is the main table on a separate tab that contains all of the formulas. I have another table on a separate tab that is part of a printable dashboard. The headers for both table are dates. What I would like to do is put a formula in the dashboard table that references the main table. I would like it to check the header of the dashboard table, find that matching header in the main table, and return the value of a specific row under that matching column header.

    For example: Both tables are structured as such, with dates extending from D1 and on. My problem is, I can't fit all of these dates on the dashboard so next week, I'll replace 4/3/16 with 4/10/16 and so on. (In the dashboard table What I need cell B2 to do is look for the date in B1 over in the main table's row 1, then, when it finds a match, return the value of the main table's row 2.
    A B C
    1 Week Ending 4/3/16 4/10/16
    2 Doc Control Received (Planned)
    3 Doc Control Received (Actual)

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Find matching header between two tables and returning that column's specific row value

    Maybe this function ?


    =HLOOKUP(B$1, Sheet2!$1:$2, 2, 0)
    _________________
    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!)

  3. #3
    Registered User
    Join Date
    05-18-2016
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Find matching header between two tables and returning that column's specific row value

    Wow! I can't believe I forgot all about HLOOKUP!! Thanks so much! Works perfectly!

+ 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: 2
    Last Post: 07-18-2015, 05:19 PM
  2. Find a matching value in a specific column, VBA
    By lifeseeker1019 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2015, 09:31 PM
  3. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  4. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  5. Returning a Specific Cell's Column Header from a Row in an Array
    By zpenacho in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2011, 07:29 PM
  6. Looking up row where value goes below 0 and returning column header
    By ellieg79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2009, 11:11 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