I'm doing a mileage spreadsheet for my 2008 taxes and I want the numerical value in column C to be determined based on the text in Column B.
So if cell B6 was "Office Depot", I want cell C6 to be "8". If cell B6 is "Office Max", I want cell C6 to be "9". I know I've done this before, but for the life of me I can't remember how and I would be extremely grateful if someone could point me in the right direction.

