Vlookup for multiple columns across table without dynamic array for older Excel versions

Hi Guys,

I am looking for solution for Excel 2010 but maybe it is possible without dynamic array.

I have input data like here:
Screenshot_16.png

and now from source table i need to retrive all variables from System column characteristic for key "Topo1"&"Tier1".

Screenshot_17.png

Expected result is array:

Screenshot_18.png

Can anybody help?

If it is not possile without dynami array, please help with dynamic array approach.

Best Wishes,
Jacek

How about
In C4 copied down
=IFERROR(INDEX(Table1[System],AGGREGATE(15,6,(ROW(Table1[System])-ROW(SourceTable!$C$2)+1)/((Table1[Topology]=C$3)*(Table1[Tier]=D$3)),ROWS(C$4:C4))),"")

Thank you very much!

O wow i am not good with this fancy formulas.
But from office 2016 it will be not a problem, using FILTER and UNIQUE will solve the problem easily.

Best,
Jacek

You're welcome & thanks for the feedback.

If you are using Excel 2016, then you do not have Filter or Unique.
If you do have them, then you are running 365, in which case you need to update your profile.

O wow,

thanks this is important!

Jacek