Lookup tables are a lot easier than the If statement you created. Don't be
so hard on yourself. Millions of people have used Vlookup successfully. You
can too.

You should also learn the difference between text and numbers. Using
"$150.00" makes this text, which can't be used in other formulas. You should
use 150.00, and format it for currency.

Regards,
Fred

"Danny Boy" wrote in message
...
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",""))))))))