Look up table?
 

I am sure this is simple, but I dont know how to achieve it

I have 2 drop down lists the produce values 1-3 each
and a table A B C
1 500 550 600
2 450 500 550
3 400 450 500

How do I get the value at the intersection of the row/coloum, so if the drop
downs come up with 1 & b the answer should be $550

Thanks

Look up table?
 

I have 2 drop down lists the produce values 1-3 each
if the drop downs come up with 1 & b

If both drop downs have selections of 1,2 3 then how can the drop downs
"come up with 1 & b" ?

Whatever the case may be, this is fairly easy to do but we'll (I'll) need
some clarification.

--
Biff
Microsoft Excel MVP


"Robert_cormack" wrote in message
...
I am sure this is simple, but I dont know how to achieve it

I have 2 drop down lists the produce values 1-3 each
and a table A B C
1 500 550 600
2 450 500 550
3 400 450 500

How do I get the value at the intersection of the row/coloum, so if the
drop
downs come up with 1 & b the answer should be $550

Thanks