Forum Discussion
#excel formula - which formula to use to match text that link to the amount and output total in mth
A postscript to what I wrote before, regarding cleaning up the data to make matches so much easier.
Let's take your "Market talk" budget category as an example. In the "Inform" sheet, whoever is filling that in has been adding "event 1" or "event 2" and so on, for tracking purposes or whatever. THAT kind of information, if needed, should be made as an entry in a different column. The primary column could be headed "Budget Category" with a supplemental column (or two or three) that could be used to store such things as "event at Town Hall" or "speaker: Jane Doe" --things that are useful to know, but NOT part of the accounting procedure per se.
And then, to help with data integrity (i.e., such things as spelling consistency), there's a feature of Excel called "Data Validation" --you can see it here on the far right of this image.
Use data validation to make sure that entries under the Budget Category column are ONLY selected from an approved list. Then they'll always match.