Update date in multiple sheets

[EwatchesUSA]

Hello everyone, I have workbook with two worksheets, worksheet A has all our inventory and worksheet B we use to add and decrease items we receive and sold, we use formula to thigh the two worksheets together.
My question is we keep track of the date the item was purchased on sheet A, I want be able to enter the date in sheet B and have formula update on to sheet A
the date only if the the date changed to newer date, example item xyz can be showing in sheet B 10 times with different dates, and I want see in sheet A the last date this item came into my store.
Please advise.

Regards Mike

 

[Andrew Poulsom]

You can use a formula like:

=MAX(IF(Sheet2!A1:A10=A1,Sheet2!B1:B10))

confirmed with Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround the array formula with curly braces {}.

 

[EwatchesUSA]

Thank you for your help, I'm getting N/A, THIS WHAT MY FORMULA LOOKS LIKE
=MAX(IF(Sheet2!A2:A31=Sheet1!A2,Sheet2!B2:B32))
I do have curly on the end but the dates not changing, to the newest date.

 

[Andrew Poulsom]

Your ranges aren't the same size:

A2:A31
B2:B32

 

[EwatchesUSA]

The range is changing every day because we add items everyday with new date

 

[Andrew Poulsom]

The ranges must be the same size or you will get #N/A. You can use eg:

=MAX(IF(Sheet2!A2:A1000=Sheet1!A2,Sheet2!B2:B1000))

 

[EwatchesUSA]

Hi, I'm still getting N/A error here is my formula

=MAX(IF('NEW DECREASE PAGE'!B4:B4749=INVENTORY!B4,'NEW DECREASE PAGE'!M4:M4749))

I did use ctr **** enter and still no luck, please advise I need to be able to have the date changes we are doing it manually now.

Regards Mike

 

[Andrew Poulsom]

The formula will return #N/A if one or more of the referenced cells contains #N/A.

 

[EwatchesUSA]

No N/A I do have blanks will that make different

 

[Andrew Poulsom]

No, blanks won't make a difference.