Nesting Lookup Functions
1 Jan Feb Mar Apr May
2 110 100 200 400 800 1600
3 120 200 400 800 1600 3200
4 130 400 800 1600 3200 6400
5 340 800 1600 3200 6400 12800
6 345 1600 3200 6400 12800 25600
7 350 3200 6400 12800 25600 51200
8 360 6400 12800 25600 51200 102400
Feb
130 800
~=HLOOKUP($L$87,$M$75:$R$82,INDEX($L$76:$L$82,MATC H(L89,M76:M82,0))
+1,FALSE)
I have gotten to like the combo of Match/Index better than the
lookups. try this for the combo. The 1,2,3 were column L starting at
row 75 for the formula.
|