I need an excel formula to correctly select the position pay amount when that position number is selected from the drop down on the Projects Tab. The pay amount information is on Sheet1.
I am currently using the following formual to calculate how much based on certain criteria:
Where the 500 is listed is where i need it to be dynamic and based upon what is selected on the drop down.
Ideas and suggestions are welcomed. Please see the attached.