I have two tables pictured below:
Table 1
<tbody>
</tbody>On cell C5 I want a vlookup function that will look at both table 1 and table 2 to get me the corresponding data. If the day of the month ranging from 18 - 4 are the same, the dept are the same (Service,sales, etc) and the Month from Table 1 is the same, get me the data within the range of C15:Q21.
I will be very thankful if someone can assist.
Thank you
Table 1
Columns | |||||||||||||||||||
Rows | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | ||
1 | |||||||||||||||||||
2 | Day of month | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 1 | 2 | 3 | 4 | |||
3 | Date | 2/18/2015 | 2/19/2015 | 2/20/2015 | 2/21/2015 | 2/22/2015 | 2/23/2015 | 2/24/2015 | 2/25/2015 | 2/26/2015 | 2/27/2015 | 2/28/2015 | 3/1/2015 | 3/2/2015 | 3/3/2015 | 3/4/2015 | |||
4 | Month | February | February | February | February | February | February | February | February | February | February | February | March | March | March | March | |||
5 | Service | ||||||||||||||||||
6 | Sales | ||||||||||||||||||
7 | Reserve | ||||||||||||||||||
8 | |||||||||||||||||||
9 | |||||||||||||||||||
10 | |||||||||||||||||||
11 | Table 2 | ||||||||||||||||||
12 | |||||||||||||||||||
13 | Day of month | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 1 | 2 | 3 | 4 | |||
14 | Service | Month | |||||||||||||||||
15 | January | 25 | 14 | 13 | 13 | 11 | 19 | 19 | 28 | 22 | 14 | 23 | 22 | 9 | 13 | 23 | |||
16 | February | 32 | 18 | 17 | 11 | 11 | 21 | 15 | 32 | 25 | 19 | 20 | 23 | 10 | 11 | 29 | |||
17 | March | 25 | 17 | 29 | 8 | 8 | 30 | 23 | 25 | 23 | 23 | 21 | 18 | 14 | 17 | 23 | |||
18 | Sales | ||||||||||||||||||
19 | January | 28 | 15 | 26 | 14 | 11 | 25 | 24 | 28 | 20 | 29 | 27 | 23 | 12 | 17 | 26 | |||
20 | February | 35 | 18 | 21 | 14 | 12 | 21 | 23 | 42 | 26 | 24 | 26 | 25 | 10 | 22 | 32 | |||
21 | March | 33 | 22 | 22 | 11 | 17 | 33 | 24 | 32 | 31 | 25 | 21 | 35 | 16 | 17 | 30 | |||
<tbody>
</tbody>
I will be very thankful if someone can assist.
Thank you