Excel VLOOKUP with Multiple Critera
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
pls try as Array formula
=INDEX(SampleData[Max iOS],MATCH(C4&C5,SampleData[Generation]&SampleData[Released],0))
=INDEX(SampleData[Max iOS],MATCH(C4&C5,INDEX(SampleData[Generation]&SampleData[Released],,),0))
IT Senior Engineer
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?
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions