Finding value from a range and if not match then find next

[annux3]

Hello,

I have a table that contains passive and active devices. I want to find correct active device to which passive device is connected. However passive device can be connected to another passive device and after that to an active device - could be endless times a passive device is connected to passive device and then in the end to an active device.

I will include excel tables with data and wanted result.



The criteria is i think something like this:

TYPE IS D3P AND Mark DOES NOT CONTAIN "ZUUM" AND Sort IS "Passive"

I have no idea how to put that into query or if its even possible to do with query?
I got the result via doing excel function index-match for like 5 times and excel stalling.

Any ideas? or questions?

Thank you,

A.

[June7]

Maybe:

SELECT * FROM tablename WHERE [TYPE] = "D3P" AND NOT [Mark] LIKE "*ZUUM*" AND [Sort] = "Passive"

[annux3]

Thats the 1st part of the query I think. now that all wanted passive devices are found I need to find active device for them - taking dev_id from passive device row and searching it from all the IDs, if found ID has "active" in its row then its a match, if it has passive then it takes on this row dev_id and searches for the next one.

[June7]

I expect that will require VBA procedure.

[annux3]

I will move this to the VBA/programming section then. Thank you.