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,
Bookmarks