I'm somewhat of an Excel "newbie", so attempting to setup a lookup table and
use VLOOKUP function would be difficult for me. Thanks for the suggestion
however.

"Teethless mama" wrote:

Setup a lookup table and use VLOOKUP function


"Danny Boy" wrote:

The Formula below works, but feels quite sloppy, and I'm sure it can be
accomplished in a much cleaner fashion. In addition, I attempted to add 1
more condition, but realized that I cannot add yet an 8th condition without
receiving an error message (I believe the limit is 7). Any suggestions to
clean the formula below up, and add the following 8th condition:

=IF(A5="PD Reports Not Provided","$100.00"

=IF(A5="Administrative Discharge Fee","$150.00",IF(A5="Medication Non
Compliance Fee","$50.00",IF(A5="Taxi Fees","$10.00",IF(A5="Phase Program No
Show Fee","$150.00",IF(A5="Record(s) Not Provided Fee","$100.00",IF(A5="BC
Not Provided Fee","$50.00",IF(A5="File Re-Opening Fee","$150.00",""))))))))