+ Reply to Thread
Results 1 to 3 of 3

Find value in row and column and get intersecting data

Hybrid View

  1. 06-15-2014, 09:51 PM #1
    coopman64
    coopman64 is offline
    Registered User
    Join Date
    10-09-2012
    Location
    Mesquite, Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Find value in row and column and get intersecting data

    I know this should be easy, but I just can't seem to get it figured out. I have a table with 16 columns of teams, and what will eventually be 25 weeks of results. I'm trying to get a formula (no vba please) where it will find a certain team in the columns, find a certain week number in the rows and give me the intersecting data. For example, I want to know how many points the Thundermutts scored in week 8. How can I search through the 16 teams to find Thundermutts, then look for week 8 and get the data from that cell?
    Reply With QuoteRegister To Reply
  2. 06-15-2014, 10:11 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find value in row and column and get intersecting data

    One way...

    Data Range
    A
    B
    C
    D
    E
    F
    1
    Team1
    Team2
    Team3
    Team4
    Team5
    2
    Week1
    53
    33
    72
    75
    93
    3
    Week2
    19
    53
    71
    89
    45
    4
    Week3
    99
    87
    63
    11
    97
    5
    Week4
    72
    42
    41
    79
    60
    6
    Week5
    45
    95
    82
    90
    81
    7
    8
    9
    Week3
    Team4
    11


    This formula entered in C9:

    =VLOOKUP(A9,A1:F6,MATCH(B9,A1:F1,0),0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 06-15-2014, 10:34 PM #3
    Saarang84
    Saarang84 is offline
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Find value in row and column and get intersecting data

    Hi,

    Another way (using INDEX and MATCH) with Tony's example. Refer workbook attached.
    Attached Files Attached Files
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang
    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)

Similar Threads

  1. Finding intersecting row and column on data chart based on data input...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2014, 08:09 PM
  2. Sum column values based on intersecting criteria in row and column
    By rlbush2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 03:56 PM
  3. Mark intersecting cell "Yes" if both Column and Row Headers exist in raw data as a pair
    By tenscourts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2012, 04:30 PM
  4. Find and Insert Intersecting Values
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-09-2009, 06:51 PM
  5. Summing a column with two intersecting conditions?
    By curiousexcel in forum Excel General
    Replies: 3
    Last Post: 08-26-2008, 04:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1