View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Old to New Pricing

If I understand your question properly, you can use the following
formula in Sheet2!B1.

=IF(Sheet2!A1=Sheet1!A1,Sheet1!B1,"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jennings"
wrote in
message
...

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