Forum Discussion
Checking cell content against a list then auto-populating
I'm stuck and hoping someone can help me. I am creating an spreadsheet to track expenses. I have a list of expense categories and their associated codes. When I input an expense, and select it's cate...
There are multiple ways to do that. The easiest would be with VLOOKUP. That page, the one hyperlinked there, will also display some alternatives for your use. One factor in considering among the ways to accomplish this is whether or not the table of Expense Codes is complete now, or whether you'll be adding to it (or your company will be adding to it).
If you need help beyond that link, by all means come back and ask, but I think the explanation there should be complete enough to guide you to success on your own.