I posted the question below earlier for Biff, however, given that I
previously said that the question was resolved (clicking thank you on the
feedback request option), when it turned out I was still having difficulty, I
was not certain whether or not my additional clarification request got seen.
For that reason I am reposting as a new question. Please see “Messy Formula
Needs Clean up Help” comments for the original postings and responses that I
received (which now include the clarification I was asking Biff for).
I tried your suggestion, and I'm still a bit confused (sorry)! My first
question is about your formula.
1-What does cell A5 reference? Given that the strings and corresponding
numbers are in AA1-AA7 and AB1-AB7.
2-In what cell do I put the VLOOKUP formula so that it runs?
What I'm trying to (as you may have guessed), is to use a drop down menu
with the various charge types (Administrative Discharge Fee, Medication Non
Compliance Fee, Taxi Fees, etc) in one column, and then have the charges
themselves appear in the corresponding columns. If the drop down menu is
blank, than no charges would appear.