Help in "If" Formula to select specific value

[Amaresh Agrahara]

Hello - My first post in this forum
In the attached file, it looks like I am missing something in the formula in column L.
In column L, I just need to get to a single value based on Column K and Column F as inputs. The output should be One single number from column C.
Formula used in column L is IF(AND(($A$3:$A$585=$K3)*($B$3:$B$585=$F3)),"",($C$3:$C$585)).
Manually, I have created what the output should look like in column H and J.
Instead, I am getting an array in column L.
Thank you in advance.

A	B	C	D	E	F	G	H	I	J	K	L	M	N
Parameter	Date	Output			Date	Parameter	Output	Parameter	Output	Parameter	Output	Parameter	Output
1	2-Mar-23	209			2-Mar-23	1	209	2	204	3	209	4
2	2-Mar-23	204			3-Mar-23	1	211	2	204	3	204	4
3	2-Mar-23	207			4-Mar-23	1		2		3	207	4
4	2-Mar-23	209			5-Mar-23	1		2		3	209	4
5	2-Mar-23	210			6-Mar-23	1	209	2	205	3	210	4
6	2-Mar-23	206			7-Mar-23	1	210	2	205	3	206	4
7	2-Mar-23	210			8-Mar-23	1	208	2	206	3	210	4
8	2-Mar-23	205			9-Mar-23	1	210	2	208	3	205	4
9	2-Mar-23	208			10-Mar-23	1	207	2	203	3	208	4
10	2-Mar-23	207			11-Mar-23	1		2		3	207	4
11	2-Mar-23	208			12-Mar-23	1		2		3	208	4
1	3-Mar-23	211			13-Mar-23	1		2		3	211	4
2	3-Mar-23	204			14-Mar-23	1		2		3	204	4
3	3-Mar-23	207			15-Mar-23	1	209	2	205	3	207	4
4	3-Mar-23	209			16-Mar-23	1	208	2	205	3	209	4
5	3-Mar-23	209			17-Mar-23	1	208	2	207	3	209	4
6	3-Mar-23	202			18-Mar-23	1		2		3	202	4
7	3-Mar-23	211			19-Mar-23	1		2		3	211	4
8	3-Mar-23	204									204
9	3-Mar-23	208									208
10	3-Mar-23	206									206
11	3-Mar-23	209									209
1	6-Mar-23	209									209
2	6-Mar-23	205									205
3	6-Mar-23	209									209
4	6-Mar-23	208									208
5	6-Mar-23	212									212
6	6-Mar-23	205									205
7	6-Mar-23	209									209
8	6-Mar-23	205									205
9	6-Mar-23	207									207
10	6-Mar-23	208									208
11	6-Mar-23	204									204
1	7-Mar-23	210									210
2	7-Mar-23	205									205
3	7-Mar-23	209									209
4	7-Mar-23	209									209
5	7-Mar-23	211									211
6	7-Mar-23	207									207
7	7-Mar-23	209									209
8	7-Mar-23	204									204
9	7-Mar-23	209									209
10	7-Mar-23	208									208
11	7-Mar-23	207									207
1	8-Mar-23	208									208
2	8-Mar-23	206									206
3	8-Mar-23	209									209
4	8-Mar-23	210									210
5	8-Mar-23	212									212

 

[ETAF]

not sure i follow what you are trying to so
IF(AND(($A$3:$A$585=$K3)*($B$3:$B$585=$F3)),"",($C$3:$C$585)).

($A$3:$A$585=$K3)
this is an array of values you are testing , and then the False value is
($C$3:$C$585)
and so again an Array

can you perhaps explain what values you want on column L and how they are worked out - rather than a formula that does not work

 

[bosco_yip]

Try

In Cell L3 formula copied down:

=IF(F3="","",IFERROR(LOOKUP(1,0/(A$3:A$585=K3)/(B$3:B$585=F3),C$3:C$585),""))

or

=IF(F3="","",SUMIFS(C:C,A:A,K3,B:B,F3))

 

[Amaresh Agrahara]

Thank you for your input.
Your formula worked.
Appreciate it and learned something new today.