Joey86
08-12-2013, 11:43 PM
Hi All, just needing some excel help with a vlookup that I'm needing. Ok so I have a massive data table on worksheet (Checklist (Table_owssvr_1)) and on the worksheet (Dashboard) I have the below table, 'Year Select' is a drop-down list selection of Years and 'Month Select' is the same. But what I'm needing to do is display the results of 1-31 days for those customers based on the Year and Month selection, the result I'm needing to display is the success rate on from the (Checklist) sheet. I've tried the below formula but no success, if anyone could help it'd be appreciated. Thanks
=IF(AND(Table_owssvr_1[[#All],[Year_Calc]],'Dashboard'!B2,Table_owssvr_1[[#All],[Month_Calc]],'Dashboard'!B3,Table_owssvr_1[[#All],[Day_Calc]],'Dashboard'!C4,Table_owssvr_1[[#All],[Customer]],'Dashboard'!B5),Table_owssvr_1[[#All],[Success Rate]],FALSE)
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
1
2
Year Select
3
Month Select
4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
5
Cust 1
Success Rate (Day 1)
6
Cust 2
7
Cust 3
8
Cust 4
9
Cust 5
=IF(AND(Table_owssvr_1[[#All],[Year_Calc]],'Dashboard'!B2,Table_owssvr_1[[#All],[Month_Calc]],'Dashboard'!B3,Table_owssvr_1[[#All],[Day_Calc]],'Dashboard'!C4,Table_owssvr_1[[#All],[Customer]],'Dashboard'!B5),Table_owssvr_1[[#All],[Success Rate]],FALSE)
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
1
2
Year Select
3
Month Select
4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
5
Cust 1
Success Rate (Day 1)
6
Cust 2
7
Cust 3
8
Cust 4
9
Cust 5