Automatically Rename cells in column

[ryanerpelding]

Hello,

I would like to automatically create categories for certain transactions off my credit card statement in excel. I tried putting in a if statement, but that was only for one cell. I would like to apply multiple if statements (or something similar) to a whole column how would i got about doing this?

For instance i started out with a if statement that follows...

=If(b2="Albert's Mexican Food", Restaurant, "")

I would then add multiple if statements such as this, and automatically return the category to the specified column.

[Tony Valko]

Instead of using a bunch of nested IF functions, create a table and use a lookup function.

http://contextures.com/xlFunctions02.html

[ryanerpelding]

Great, thanks for the help!

[Tony Valko]

You're welcome!