BuffaloGuy
New Member
- Joined
- Dec 5, 2017
- Messages
- 28
If I have a table in Sheet 1:
<tbody>
</tbody>
And I have a Drop down List in Sheet 2 that references the top row of Sheet1 (in B2): NY, ID, WA, CO, RI.
<tbody>
</tbody>
Can I use a Vlookup to get the Answer I need in D2?
NY | ID | WA | CO | RI | |
1 | .1 | .2 | .3 | .4 | .5 |
2 | .2 | .3 | .4 | .5 | .6 |
3 | .3 | .4 | .5 | .6 | .7 |
4 | .4 | .5 | .6 | .7 | .8 |
5 | .5 | .6 | .7 | .8 | .9 |
<tbody>
</tbody>
And I have a Drop down List in Sheet 2 that references the top row of Sheet1 (in B2): NY, ID, WA, CO, RI.
List | NY, ID, WA, CO, RI |
REF: | 2 |
Question: | 100 |
Answer | =C2*(Cell in Column from List and Row B2) |
<tbody>
</tbody>
Can I use a Vlookup to get the Answer I need in D2?