Hello,

I spend so much time changing prices to which thier should be a formula for.

My problem is sheet 1 has all parts that a supplier offers (20,000) and sheet 2 is just the parts i take from them (11,000). When they change thier prices i have to search sheet 1 for the part number then copy the new price and paste it back into sheet 2. Ovioulsy this takes great time.

Is there a formula (or way) that i can do this quicker.?

What i need is a way of typing "If sheet2A1 matches sheet1A? then sheet2 B1=Sheet1 B?"