Killer_Bud
New Member
- Joined
- Nov 7, 2005
- Messages
- 21
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,