Help with Match Index and MAX Formula

[brendongl]

	A		I
1	01/05/17		Apple
2	02/05/17		Orange
3	01/06/17		Apple

<tbody>
</tbody>

Hello. I have spent quite some time making a formula to display the date for the latest sale of some of my products. I have another topic about this but those formulas did not work, i believe because the max function only operates if you are using numbers? (it says on the microsoft support site "[FONT=&quot]If the arguments contain no numbers, MAX returns 0 (zero).")
[/FONT]
Column A is actually a formula giving them date as it is a vlookup function. Maybe that is why i have been failing making this formula??

 

[Aladin Akyurek]

It seems we have a hard to communicate. I magine that

1. you have an area (Area1) where you have a bunch of SKU's. Some of these are duplicates, i.e. they recur in this area.
2. you want to establish the last date which corresponds to each SKU in a target area (Area2).

a) What is the range in Area1 which houses SKU's?
b) What is the range in Area1 where must implement the look up formula we need?
c) What is the range in Area2 against which the SKU of Area1 must be matched?
d) What is the range in Area2 from which the last date must be returned?

Please indicate the ranges in a regular way like in Sheet1!A2:A200, etc.

 

[brendongl]

You are correct yes.

a) SalesRecord!I2:I690
b) Does not exist, the lookup formula is only going on ItemList sheet
c) Confused...ItemList has 1258 Rows. Each row has a unique SKU. so ItemList!a2:a1258?
d) The last date is not returned FROM ItemList...The formula will exist in ItemList but grab the date from SalesRecordA2:a690

The formula you have provided does work, but causes mass delay even when i enter it once on one row so i have opted not to use it. I am certain there is a way to achive the same result with index match max.
Thank you for your help thus far.

 

[Aladin Akyurek]

You are correct yes.

a) SalesRecord!I2:I690
b) Does not exist, the lookup formula is only going on ItemList sheet
c) Confused...ItemList has 1258 Rows. Each row has a unique SKU. so ItemList!a2:a1258?
d) The last date is not returned FROM ItemList...The formula will exist in ItemList but grab the date from SalesRecordA2:a690

The formula you have provided does work, but causes mass delay even when i enter it once on one row so i have opted not to use it. I am certain there is a way to achive the same result with index match max.
Thank you for your help thus far.

It seems it's hard to get a clear picture of the lay-out of your (input) data and the lay-out of (output) processing. Hard to understand why you keep telling a would-be helper the type of formula s/he should craft.