Hey All!
I'm getting stuck on how to use an index formula to get the data I'm looking for. Below is the data that I need to index. On another tab, there are two drop downs. One dropdown to select an option in bold, and one to select an option that is underlined below. (This info starts in A1, ends in D7)
I need a formula that will automatically pull the right price based on the user selection. Maybe an Index won't work in this scenario?
Thanks in advance for your help!
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"]OPM [/TD]
[TD="class: xl66, width: 64"]EOW [/TD]
[TD="class: xl66, width: 64"]OPW[/TD]
[/TR]
[TR]
[TD="class: xl66"]NO RCY[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"]CRY[/TD]
[TD="class: xl67"]$0.68 [/TD]
[TD="class: xl67"]$1.49 [/TD]
[TD="class: xl67"]$2.97 [/TD]
[/TR]
[TR]
[TD="class: xl66"]RBN[/TD]
[TD="class: xl67"]$0.14 [/TD]
[TD="class: xl67"]$0.30 [/TD]
[TD="class: xl67"]$0.59 [/TD]
[/TR]
[TR]
[TD="class: xl66"]32Y[/TD]
[TD="class: xl67"]$0.27 [/TD]
[TD="class: xl67"]$0.59 [/TD]
[TD="class: xl67"]$1.19 [/TD]
[/TR]
[TR]
[TD="class: xl66"]64Y[/TD]
[TD="class: xl67"]$0.41 [/TD]
[TD="class: xl67"]$0.89 [/TD]
[TD="class: xl67"]$1.78 [/TD]
[/TR]
[TR]
[TD="class: xl66"]96Y[/TD]
[TD="class: xl67"]$0.68 [/TD]
[TD="class: xl67"]$1.49 [/TD]
[TD="class: xl67"]$2.97 [/TD]
[/TR]
</tbody>[/TABLE]
I'm getting stuck on how to use an index formula to get the data I'm looking for. Below is the data that I need to index. On another tab, there are two drop downs. One dropdown to select an option in bold, and one to select an option that is underlined below. (This info starts in A1, ends in D7)
I need a formula that will automatically pull the right price based on the user selection. Maybe an Index won't work in this scenario?
Thanks in advance for your help!
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"]OPM [/TD]
[TD="class: xl66, width: 64"]EOW [/TD]
[TD="class: xl66, width: 64"]OPW[/TD]
[/TR]
[TR]
[TD="class: xl66"]NO RCY[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"]CRY[/TD]
[TD="class: xl67"]$0.68 [/TD]
[TD="class: xl67"]$1.49 [/TD]
[TD="class: xl67"]$2.97 [/TD]
[/TR]
[TR]
[TD="class: xl66"]RBN[/TD]
[TD="class: xl67"]$0.14 [/TD]
[TD="class: xl67"]$0.30 [/TD]
[TD="class: xl67"]$0.59 [/TD]
[/TR]
[TR]
[TD="class: xl66"]32Y[/TD]
[TD="class: xl67"]$0.27 [/TD]
[TD="class: xl67"]$0.59 [/TD]
[TD="class: xl67"]$1.19 [/TD]
[/TR]
[TR]
[TD="class: xl66"]64Y[/TD]
[TD="class: xl67"]$0.41 [/TD]
[TD="class: xl67"]$0.89 [/TD]
[TD="class: xl67"]$1.78 [/TD]
[/TR]
[TR]
[TD="class: xl66"]96Y[/TD]
[TD="class: xl67"]$0.68 [/TD]
[TD="class: xl67"]$1.49 [/TD]
[TD="class: xl67"]$2.97 [/TD]
[/TR]
</tbody>[/TABLE]