Forum Discussion
Need Help with combining formulas
I am attempting to combine List using Data Validation and a formula to take written information and attach a number amount. My goal is to create a system for creating a budget.
2 Replies
Hi David,
I would add an extra 'Combo' column in the sheet1, and then use INDEX/MATCH in sheet2 to look up for budget items from sheet1. Please see attached for a solution.
Hope this helps
Yury
Yury,
Thank you so much. I was losing my mind on that. I'm good with standard information, but I could not figure out the combination information. This truly helped.
Thank you,
David
