Look at the VLookup formula in help.
--
HTH...

Jim Thomlinson


"Roy E" wrote:

I am looking to have linked as if I would type a model # on one sheet and it
would find the price of the unit and fill it in. I will have different models
with different prices on a sheet. Would it find the Price any where in a
sheet to go with the type model I type in? Thanks