Hi there ... I'm trying to create a budget sheet (even though there are millions of templates out there :D) and can't seem to figure out how to make this work. It should be quite simple for some experts in this forum, so here goes:

I have Expenses in A1, A2, A3 ... all the way to A12. I have a set budget number in B2 ... A12. From C2 - C12, I have the actual amount expensed.

Starting at A20 to A300, I will be listing the expense (e.g. car payment, insurance payment etc.), and in C20 to C300 I will be including the amount expended.

Basically, what I want is in cells C2 to C12 to pull the value from C20 to C300 based on the text value in A20 to A300. So for example, under A2 I have car payment. I would like to enter a formula in C2 that says "if any cell from A20 to A300 equals "car payment", then C2 will equal the corresponding same C row from C20 to C300" Does that make sense? It does in my head hahaha

So I've got up to this point =IF(ISNUMBER(MATCH("car payment",$A$20:$A$300,0)),[I DON'T KNOW WHAT GOES HERE],0)

Help would be greatly appreciated, thank you!