formulas for transferring data validation information in excel 200
 

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

Hi
use VLOOKUP for this. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Tony" schrieb im Newsbeitrag
...
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