I need to lookup the Max iOS value based upon the generation lookup value and the lowest release lookup value and where the description contains the lookup value.
Generation Lookup is already calculated, along with the lowest release date.
I have attached my Excel file for further help.
I expect I will need an array formula, but am not "expert" enough to work out how to build it.
Thank you. This doesn't seem to include the "must contain" the lookup value (ipad air).
This is needed because there could be multiple product types released on the same day with the same generation number, but with different max is versions.
pls try as Array formula
Open in new window
Regards