ExcelBanter - Help with formula please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with formula please (https://www.excelbanter.com/excel-worksheet-functions/5948-help-formula-please.html)

NT6192

Help with formula please

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

Frank Kabel

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

All times are GMT +1. The time now is 05:48 AM.