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?"


--
Jennings
------------------------------------------------------------------------
Jennings's Profile: http://www.excelforum.com/member.php...o&userid=31466
View this thread: http://www.excelforum.com/showthread...hreadid=511484