Forum Discussion
#excel formula - which formula to use to match text that link to the amount and output total in mth
Hi Anyone can help and advice the formula. I have two spreadsheet need to get the formula to auto total up the amount that matches the item foe the mth. See sample How can I get the total ...
To what extent are you able to make fundamental changes to how these data elements are collected in the first place?
The basic formulas you are looking for are fairly simple, but your data are (sorry) something of a mess, and that will make it tricky unless it's all cleaned up.
What do I mean by "mess"? A few examples
- in your budget sheet, you list "Market Talk" as the first item, but on the Inform sheet, it's "Market Talk - Event 1" ---> so although the first two words match, the cells themselves don't. It could be accommodated, but it'd be better to not have to complicate things like that.
- in your budget sheet, you list" HR - Claim" but in Inform it's "HR claims" You and I as human beings will see that as the same; a computer sees it as quite different
- and so on
If you upload an actual spreadsheet instead of an image, it would be easier to give you an example of a working formula, but you really truly need to look into cleaning up your data so matches can be made.