Help with formula please

N

NT6192

I have already added a validation list for column A with 20 agents. So when i
select for example agent 5 i need it to know what their %commission rate is
and auto populate that into a cell in Column B.

Does anyone know a formula for this.

Thanks
 
Top