Perhaps this would help clarify Teethless Mama's earlier response a little
further ...

Assume your "good sized" table is in Sheet2, where A1:A100 and B1:B100
contain values corresponding to the values within the 2 dropdowns (in say,
Sheet1's C1 and D1 respectively), and the value to be returned is from C1:C100

Then in Sheet1,
with the dropdowns in C1 and D1

you could use something like this in say, E1:
=INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:A100=C1)* (Sheet2!B1:B100=D1),0))

Remember to array enter the formula with CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"price guy" wrote:
.. Regarding the ranges you have C1:100, A1:A100 etc,
columns a,b, c would be which variable? the drop down with three options?