Excel VLOOKUP with Multiple Critera

Hello,

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! :)
Simplified.xlsx

Microsoft ExcelMicrosoft Office

Last Comment

Terry Rogers

8/22/2022 - Mon

Rgonzo1971

4/4/2017

Hi,

pls try as Array formula

=INDEX(SampleData[Max iOS],MATCH(C4&C5,SampleData[Generation]&SampleData[Released],0))

Open in new window

Regards

Ejgil Hedegaard

4/4/2017

Add Index to the Match range in Rgonzo's formula, and it can be a regular formula

=INDEX(SampleData[Max iOS],MATCH(C4&C5,INDEX(SampleData[Generation]&SampleData[Released],,),0))

Open in new window

Terry Rogers

4/4/2017

ASKER

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.

How would we add this criteria to the formula?

Your help has saved me hundreds of hours of internet surfing.

fblack61

ASKER CERTIFIED SOLUTION

Rgonzo1971

4/4/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts