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

[Primo]

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

 

[mrmmickle1]

Try something like this:

Excel 2012
	A	B	C	D	E	F	G
1	Data	Data	Expense Autofill	Type # Here		Expense Classification	Description
2	Data	Data	Expense1	1		1	Expense1
3	Data	Data	Expense2	2		2	Expense2
4	Data	Data	Expense5	5		3	Expense3
5	Data	Data	Expense1	1		4	Expense4
6	Data	Data				5	Expense5
Sheet1

Cell Formulas
Range	Formula
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]

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

You da man!

Primo

 

[mrmmickle1]

No problem! Glad to help out.