+ Reply to Thread
Results 1 to 2 of 2

How to find data on a another sheet dependent on cells, rows and columns

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel for Mac 2011
    Posts
    22

    How to find data on a another sheet dependent on cells, rows and columns

    Hi,

    I'm really not sure what this is called so sorry if the description and tags aren't very clear. But I'll try my best to explain.

    I'm putting together a sheet that from a drop down list of months will go fetch data for that month in another sheet in the same workbook. But I have around 100 different rows for various measurements. Is there a 'generic' formula that will read the row name, look at month is listed on the drop down and return the value. Instead of doing individual SUMIF?

    For example on the attached - on the Month column in cell C3 I want a formula that reads A3 'Problem', M2, 'Jan' (which would be a drop down) and then on sheet 2 return the value for Number of problems in Jan, in this case 3.0 and then if I changed the month to Feb it would then return in this example 0.5 in cell D3.

    I hope this makes sense. I think basically I'm looking for a generic formula that saves me having to write individual formulas. The example is one of about 20 I need to do, hence the need for a time save?

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,827

    Re: How to find data on a another sheet dependent on cells, rows and columns

    In M3

    =INDEX(Sheet2!$C$3:$P$10,MATCH(Sheet1!$A$3,Sheet2!$A$3:$A$10,0),MATCH(Sheet1!$M$2,Sheet2!$C$1:$P$1,0))

+ 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. Using Small to find other columns/rows in the data
    By rpinxt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2016, 11:27 AM
  2. Find multiple keywords in all columns and copying discovered rows into new sheet
    By noxfinitie in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 07-03-2014, 01:14 PM
  3. Replies: 10
    Last Post: 08-14-2013, 03:32 PM
  4. [SOLVED] Macro to Reverse Order of Columns but Dependent on Number of Data Rows
    By francois28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 06:34 PM
  5. find values between cells and paste in rows of another sheet
    By manmeet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2010, 01:57 AM
  6. Replies: 3
    Last Post: 03-19-2009, 09:11 AM
  7. Find data in columns, then place in rows
    By couriced in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2005, 12:44 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1