lookup

  • Thread starter Thread starter anna
  • Start date Start date
A

anna

I have a sheet that contains prices for products. These
products have sku numbers.

Some of the products prices get updated monthly while
some prices won't change.

I've organized the sheet so that it has 2 columns.

One that has the updated price listings and another that
has the old prices.

In another cell i want a date inserted based on when the
prices were updated.

What i want is a formula that will look at the updated
column and compare it to the old prices. If the price
matches then it will keep it's old date else it will get
a date from another cell.

Understand???

Example:

sku # New price: Last Price: Date:
1115781 2351.00 3254.23
 
I don't think there's a simple formula that will do
that. But try something like this: Before you enter the
new pricing, copy the date column (VALUES only) off to
the right .. say column x. Then, enter the new prices.
The date column should contain the formula =IF(price
old=price new, old date, new date), where price old is
the old price cell, new price is the new price cell, old
date is column x and the row you're in, and new date is a
fixed cell in which you've entered the new date (e.g.
$y$1 .. don't forget the $ so it accesses the same cell
as you go down the rows)
 
Back
Top