Look up table?

R

Robert_cormack

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
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top