Output unique list from table with certain criteria - formula

Hi Guys,

in attachment please find example workbook.
I have table source and using Search function to lookup for all SystemNames for 2 servers - "Cloud Server" and "B777" (cell A2 in sheet "With one Value").
You can see there is a function.

This is ok but i have to add one more condition field here - "Topo2" - because i want to get only SystemNames for these 2 servers and "Topo2".
When i am adding into Cell "A2" "Topo2" i have error so search function within my whole function is not working properly.

How to solve this?

Please help,
Best,
Jacek

Please try at C3 and press Ctrl+Shift+Enter

Formula:

Please Login or Register  to view this content.

Hi Bo_Ry,

wow your formula is enormous!

i pasted your code into Sheet("With one Value") and i have not expected result:

Screenshot_28.png

Best,
Jacek

Sorry not C3 you need to put that on A3 or
for C3 You need to change COUNTIF(A$2:A2 to COUNTIF(C$2:C2

hmm thank you!

i hope that others will gigure out also something because your formula is very very big...

Best,
Jacek

Hi,

no shorter way to do this?

Best,
Jacek

Hi,

please help,
Jacek

Hmm, this is not working at all.

I changed lookup value to:

"Cloud ServerB555" and i should get only Windows 7 and Windows 11 and Windows XP but i have additionally Linux which is characteristic for B777, not for B555...

Please help,
Best,
Jacek

hi Glenn,

thank you very much you are master!!!

one question:

Please Login or Register  to view this content.

what does this "/" sign mean here?

It will take 6 here but why?

"*" means AND in formula.

Best,
Jacek

thank you Glenn,

it is possible to instead of "TableSource!D:D" input structure table reference here?
It is imporant for my model...

Best,
Jacek