I have the following data table:
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.
Any help would be much appreciated! :)