Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |