if you could redesign your sales commission list into several ones, you could make them hierarchically dependent (cascaded) which would help you then to filter just by single key and with few nested lookup you could get what you need.

I have meant it, if there is at least one item in 'IP PLans" list that in field 'RD Name" have a name that's in variable EmployeeName.

furthermore there might be a datatype problem - if 'RD Name" is people&group type filed and you query by I EmployeeName string that can not be recognized/converted to people&group entity, lookup will obvioulsy fail.