Hi Zone,

Thanks for the continued support on this!

I have two sheets, each is a list of about 30 parts. The first sheet is a
list of 30+ different parts (the accessories) such as nuts, bolts, washers,
and other things we use to assemble final parts with the price of each beside
it. The final parts are what are on the second list. All of the parts on
the second list are pretty similar, but there are slight difference in their
size, what gets bolted on them, the size of bolts and washers etc. Because
of this all parts on the second list (the final parts) use a slightly
different mix of what is on the first list (nuts, bolts etc).

What I have is a bill of materials for all these final parts that lists what
combination of accessories each one uses. When the price of an accessory
changes it becomes a pain to search through each part and change the price
manually. So what I was hoping to do is get the second lists, the final
parts list, to automatically update from the first list.

I hope this helps.

Thanks!

"Zone" wrote:

Hi Cam,
Sorry I wasn't able to get back to you earlier. You'd have to explain the
layout of the two sheets and give me a specific example of what you're
wanting to do. Do some accessories go into more than one part? James

"Cam1234" wrote in message
...
Hey Zone,

They are on different sheets. I was hoping there is some formula that
says
"when x is in this cell, return the value to the left of x on this sheet".

Thanks!

"Zone" wrote:

Cam, are the two lists on the same sheet or different sheets? You could
write a formula to add up the prices of the individual accessories that
make
up each part. If there are a lot of accessories in each part, you could
end
up with a very long formula. Might be easier to do it with a macro.
James

"Cam1234" wrote in message
...
Hi All,

I have a price list with 60+ accessories whose prices always change.
There
is another list of about 30 parts that use different combinations of
these
accessories to make a final part. I need to update these values
monthly,
and
instead of updating the same one over and over, I would rather update
the
accessories list and have the list of the 30 parts automatically update
from
the accessories list.

Any ideas?

Thanks in advance,

Cam