Formula Help

[Killer_Bud]

Style W Formula Page1.xls
	K	L	M	N	O	P	Q	R	S	T
1		0	0.25	0.375	0.5	0.625	0.75	0.875	1	1.25
2	0.25	1	2.85	3.51	4.48	5.45	7.03	9.25	13.40	24.73
3	0.25	2	3.78	4.85	6.21	7.59	9.56	11.25	15.63	23.28
4	4	3	4.80	6.28	8.05	9.85	12.10	14.20	18.98	26.03
5	5.83	4	5.83	7.70	9.91	12.13	14.86	18.06	22.31	30.16
6	0.375	5	6.88	9.15	11.73	14.41	17.40	21.48	25.65	34.31
7		6	7.93	10.60	13.59	16.70	20.19	24.41	29.00	39.85
8		7	9.81	12.89	16.38	20.50	24.48	28.76	33.46	45.40
9		8	11.43	14.90	18.85	22.94	27.81	32.81	38.48	52.35
10		9	13.56	17.45	21.93	26.58	32.06	37.65	43.75	59.29
11		10	16.00	20.28	25.23	30.50	36.63	43.20	50.23	67.64
Sheet1

Can someone please help me.
In cell K5 I'd like a formula to go:

=IF(K6>K2,VLOOKUP(K4,L1:T52,MATCH(K6,L1:T1,0),0)),IF(K6="",MATCH(K3,L1:T1,0))

I keep getting an error and I can't tell why. Any ideas ?

Thanks,

 

[Andrew Poulsom]

Misplaced closing parenthesis:

=IF(K6>K2,VLOOKUP(K4,L1:T52,MATCH(K6,L1:T1,0),0),IF(K6="",MATCH(K3,L1:T1,0)))

 

[Killer_Bud]

still getting an #N/A error

 

[Jon von der Heyden]

Worked for me...

Book1
	K	L	M	N	O	P	Q	R	S	T
1		0	0.25	0.375	0.5	0.625	0.75	0.875	1	1.25
2	0.25	1	2.85	3.51	4.48	5.45	7.03	9.25	13.4	24.73
3	0.25	2	3.78	4.85	6.21	7.59	9.56	11.25	15.63	23.28
4	4	3	4.8	6.28	8.05	9.85	12.1	14.2	18.98	26.03
5	7.7	4	5.83	7.7	9.91	12.13	14.86	18.06	22.31	30.16
6	0.375	5	6.88	9.15	11.73	14.41	17.4	21.48	25.65	34.31
7		6	7.93	10.6	13.59	16.7	20.19	24.41	29	39.85
8		7	9.81	12.89	16.38	20.5	24.48	28.76	33.46	45.4
9		8	11.43	14.9	18.85	22.94	27.81	32.81	38.48	52.35
10		9	13.56	17.45	21.93	26.58	32.06	37.65	43.75	59.29
11		10	16	20.28	25.23	30.5	36.63	43.2	50.23	67.64
Sheet1

 

[Killer_Bud]

seems to work when K6>K2, but when K6="", I get an #N/A ?
This is what I need to correct. When K6="", I need it to match K3
to L1:T1

 

[Jon von der Heyden]

Still works for me...

Book2
	K	L	M	N	O	P	Q	R	S	T
1		0	0.25	0.375	0.5	0.625	0.75	0.875	1	1.25
2	0.25	1	2.85	3.51	4.48	5.45	7.03	9.25	13.4	24.73
3	0.25	2	3.78	4.85	6.21	7.59	9.56	11.25	15.63	23.28
4	4	3	4.8	6.28	8.05	9.85	12.1	14.2	18.98	26.03
5	2	4	5.83	7.7	9.91	12.13	14.86	18.06	22.31	30.16
6		5	6.88	9.15	11.73	14.41	17.4	21.48	25.65	34.31
7		6	7.93	10.6	13.59	16.7	20.19	24.41	29	39.85
8		7	9.81	12.89	16.38	20.5	24.48	28.76	33.46	45.4
9		8	11.43	14.9	18.85	22.94	27.81	32.81	38.48	52.35
10		9	13.56	17.45	21.93	26.58	32.06	37.65	43.75	59.29
11		10	16	20.28	25.23	30.5	36.63	43.2	50.23	67.64
Sheet1

 

[Andrew Poulsom]

Null is greater than any number in the sort order, so your first test is still true:

IF(K6="",MATCH(K3,L1:T1,0),IF(K6>K2,VLOOKUP(K4,L1:T52,MATCH(K6,L1:T1,0),0)))

 

[Killer_Bud]

I need my formula to perform this function:

=IF(K6="",VLOOKUP(K4,L1:T52,0,MATCH(K3,L1:T1,0),IF(K6>K2,VLOOKUP(K4,L1:T52,MATCH(K6,L1:T1,0),0)))

Unfortunately this is too many arguments for this to work.
Is there a way to get it to do this?

 

[Andrew Poulsom]

Shouldn't it be?

=IF(K6="",VLOOKUP(K4,L1:T52,MATCH(K3,L1:T1,0),0),IF(K6>K2,VLOOKUP(K4,L1:T52,MATCH(K6,L1:T1,0),0)))

 

[Killer_Bud]

Thank you, Thank you, Thank you !!!!
Works Excellent !!!!!!!!