Vlookup from List

[BuffaloGuy]

If I have a table in Sheet 1:

	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?

 

[Jon21990]

Try this:

=c2*vlookup([cell reference of "ref"],sheet1!A:F,match([cell ref of dropdown list],sheet1!A1:F1,0),false)

Thanks
Jon