# Developing a Budget- Need a formula to help increase the organization

#### Primo

##### New Member
Hey Mr. Excel guy, I hope all is well today.

I a developing a budget for myself and on the right side of the spreadsheet is a column of general expenses in text. Next to those individual expenses are numbers 1-10. I have Column C designated for the appropriate 'expense ID' that will come from that list on the right side of the spreadsheet. In column D, I would like to be able to type in the number (For example, '1') and have it pull into Column C the appropriate expense name that it correlates with on the right side of the spreadsheet.

I hope this makes clear sense. Thank you a ton for the help!!

Have an awesome day. Please let me know what you find!

Cheers,

Primo

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### mrmmickle1

##### Well-known Member
Try something like this:

Excel 2012
ABCDEFG
Sheet1
Cell Formulas
RangeFormula
C2=IFERROR(INDEX(\$F\$2:G\$6,MATCH(D2, \$F\$2:\$F\$6, 0), 2), "")
C3=IFERROR(INDEX(\$F\$2:G\$6,MATCH(D3, \$F\$2:\$F\$6, 0), 2), "")
C4=IFERROR(INDEX(\$F\$2:G\$6,MATCH(D4, \$F\$2:\$F\$6, 0), 2), "")
C5=IFERROR(INDEX(\$F\$2:G\$6,MATCH(D5, \$F\$2:\$F\$6, 0), 2), "")
C6=IFERROR(INDEX(\$F\$2:G\$6,MATCH(D6, \$F\$2:\$F\$6, 0), 2), "")

#### Primo

##### New Member
Oh yeah baby! That works perfectly. Thanks for the help mrmmickle1!

You da man!

Primo

#### mrmmickle1

##### Well-known Member
No problem! Glad to help out.

Replies
3
Views
659
Replies
7
Views
133
Replies
13
Views
724
Replies
3
Views
243
Replies
6
Views
778

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,714
Messages
5,833,276
Members
430,201
Latest member
Deepakpilla36

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back