Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"NT6192" schrieb im Newsbeitrag
...
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