The following formula will work, providing the Data Validation is properly applied:Here is a copy of your file with the formula and data validation applied:![]()
=D2*INDEX(Calculations!$D$2:$D$7,MATCH(C2,Calculations!$C$2:$C$7,0))
Copy of Donation calculatuions.xlsx
Let me know if you have any questions.
Bookmarks