Apply filter based on a condition and predict the matching ID

[Kevin8819]

Hi everyone,

Great if anyone can help with this. I have two sheets,

1) Data - Contains data of pupil from different countries in different age groups with their unique IDs

2) Condition - Contains different combination of countries and age group

Expected output - Looking to filter "data" sheet based on the criteria in "Condition" sheet and predict the matching unique IDs for different condition

Test workbook

P.S. I have to this on over 150K rows and would only need 5 matching IDs for every test.

Any help will be greatly appreciated

Thanks
Kane

 

[Kevin8819]

This is Awesome, thank you very much Peter!

 

[Peter_SSs]

This is Awesome, thank you very much Peter!

You're welcome.

In the end, is it worksheet functions or UDF for you?

 

[Kevin8819]

You're welcome.

In the end, is it worksheet functions or UDF for you?

UDF! Simple and Easy. Thanks so much again!

 

[Peter_SSs]

UDF! Simple and Easy. Thanks so much again!

Thanks, I was just curious.