My question is:

I have a range of data that looks something like this:

Account
100000
100001
100002
100003
100004

What I would a formula to be written that can help me put the above information into a category e.g. for data ranging between 0 and 100003 it equals to Expense.

If you could please kindly assist me with this matter. It would be much appreciated

---

Answer from Richard Rost:

You could use an IF function, or the VLOOKUP function, depending on the complexity of your data. How many of these different options are there? If there are more than a couple, I would use VLOOKUP. Here's a tutorial:

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx