It was hard to title this one. Thanks in advance for your help.
In cells A30 through A34, I have the following list:
Assistant Manager
Manager
Coordinator or Treasurer
Vice President
President
We have an "approval level" control that determines who needs to sign the requisition depending on the amount. Here is the approval key:
Up to $100 Assistant Manager
$101-$500 Manager
$501-$2000 Coordinator or Treasurer
$501-$2000 Vice President
Over $2000 President
Depending on the amount in cell J27, I would like the appropriate signature people to automatically pop up.
Is this possible?
In cells A30 through A34, I have the following list:
Assistant Manager
Manager
Coordinator or Treasurer
Vice President
President
We have an "approval level" control that determines who needs to sign the requisition depending on the amount. Here is the approval key:
Up to $100 Assistant Manager
$101-$500 Manager
$501-$2000 Coordinator or Treasurer
$501-$2000 Vice President
Over $2000 President
Depending on the amount in cell J27, I would like the appropriate signature people to automatically pop up.
Is this possible?
Last edited: