How to use text from a cell in a formula, so if I change the text, the formula changes to?

[Want2BExcel]

Hi,
I have a budget table. For each month there is a formula to get data from another sheet. But the text is "fixed", so for every post (row) I manually have to change this text in all 12 months (colums).
If I use a column to specify witch text I want in the formula and rewrite only the part of the formula that specify what text to look for, then my intention is that I only need to change the text in the new column to change it in every month column. Is that possible?

My formula is (hereunder) and it's the bold text that I want to change to get text from the extra column.

SUMIF(expected.expenses[text];"Health insurance";expected.expenses[July])

I have already tried the obvious way and just write C3, but then Excel can't find the matching text in the expected.expenses sheet...

 

[Toadstool]

I'm struggling to follow what you want. Could you supply a worked example please, preferably using XL2BB ?

 

[Fluff]

have already tried the obvious way and just write C3,

Can you post the formula where you tried that?

 

[Want2BExcel]

I will reply to both of you later.... On my way to work

 

[Want2BExcel]

Can you post the formula where you tried that?

SUMIF(expected.expenses[text];[@[bankstatement.text]];expected.expenses[July])

 

[Fluff]

That should work, in what way isn't it?

 

[Want2BExcel]

I'm struggling to follow what you want. Could you supply a worked example please, preferably using XL2BB ?

I cant get XL2BB to work.
Hope these images help (just be aware that the text and formulas is in danish...that why I translated them in my question)

Image 1: here I have writen the text "BS TOTALKREDIT A/S" manually, and I have to do this for every month and for every expenses. When I do this excel finds the same text in "ANSLÅET.UDGIFTER[TEKST] and get the expense amont "-5700,00"

Image 2: when I try to point to the "Postering tekst", so that it automatic changes the text in all 12 months formulas, just by changing the text in "Postering tekst". When I do this excel does NOT find the same text in "ANSLÅET.UDGIFTER[TEKST] or get the expense amont "-5700,00"

Image 3: Is the sheet where the formula is finding/notfinding the data

 

[Want2BExcel]

That should work, in what way isn't it?

No. See my images in other reply

 

[Fluff]

If you are getting a 0, that would suggest that the text in the Postering tekst is not exactly the same as in the other table.
From the images it looks as though you may have an extra space before the A/S

 

[Want2BExcel]

If you are getting a 0, that would suggest that the text in the Postering tekst is not exactly the same as in the other table.
From the images it looks as though you may have an extra space before the A/S

WOW....I'm imbarrased :D Been fighting this for soooo many hours....and I choose to use the ONE ROW where I had an error :D :D :D NICE SPOTTED!!!! THX