Good morning Happy New Year and apologies for the "noob" question. For soem reason my head wont get around this.
I have a simple table A1:E10
I have dates in column A and headings on row 1.
Building a minor summary dashboard what I need to be able to do is have a formula that has will search the table and return the answer based ont he criteria.
Bearing in mind the date on the dashboard can be changed.
So I'd need to have a formula to search Column A and have it match with criteria in Row 1.
SO if the headers were:
<tbody>
</tbody>
If "B2" on the dashboard had "02/01/2014"
and "b3" had "Existing"
Id want the result "6"
I've tried index match, but unless I havent used it correctly (which is always a chance) I cant get it to work.
Regards.
(ps lets say the data is on sheet 1 and the dashboard on a sheet called "Dash")
I have a simple table A1:E10
I have dates in column A and headings on row 1.
Building a minor summary dashboard what I need to be able to do is have a formula that has will search the table and return the answer based ont he criteria.
Bearing in mind the date on the dashboard can be changed.
So I'd need to have a formula to search Column A and have it match with criteria in Row 1.
SO if the headers were:
Date | New | existing | Inbound | Outbound |
01/01/2014 | 1 | 2 | 3 | 4 |
02/01/2014 | 5 | 6 | 7 | 8 |
03/01/2014 | 9 | 10 | 11 | 12 |
04/01/2014 | 13 | 14 | 15 | 16 |
05/01/2014 | 17 | 18 | 19 | 20 |
06/01/2014 | 21 | 22 | 23 | 24 |
07/01/2014 | 25 | 26 | 27 | 28 |
08/01/2014 | 29 | 30 | 31 | 32 |
09/01/2014 | 33 | 34 | 35 | 36 |
<tbody>
</tbody>
If "B2" on the dashboard had "02/01/2014"
and "b3" had "Existing"
Id want the result "6"
I've tried index match, but unless I havent used it correctly (which is always a chance) I cant get it to work.
Regards.
(ps lets say the data is on sheet 1 and the dashboard on a sheet called "Dash")