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