formulas for transferring data validation information in excel 200

G

Guest

Hey,

I have a table list with part size callout in a column and material callout
in a row on sheet 1 with pricing in the table. What I want to do is on sheet
2 use data validation to pick the part size in a cell and material in a cell
then in another cell have it show me the corresponding price. I can send the
file if it will help explain. I'm sure its some type of lookup formula but
do not know. Any help is appreciated.

Thanks,

Tony
 

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

Counting the occurrence of data in one column based on two criteri 3
Solution for if x = 1 and Y =2 goto C3 2
variable in data validation 4
IF formula for 13 plus variables 3
Data Validation Formulas 3
Using Formulas for Data Validation 1
How to use the IF Function for 3 conditions 5
Vlookup and Data Validation Q 2

Top