How to create Lookup by filter on sharepoint?

enter image description here

I want to create fields which is based location, business function group, categories and designation. Each of the field should lookup to the category here. Please help me on how to lookup the details.

Example : Categories should have choices of APAC Support Service/SSC,US Support Service, Non Support Service.

Same goes to other fields