Need help with formula to convert text from one column to number in another

[lhansberry]

Im using excel 2007 and I need help entering a formula that will take the text from one column and have a number associated with it in the next column.

Example: Accident = 1
Failure = 2
Violation = 3

Please help someone PLEASE!

[oeldere]

make a table with the options and use Vlookup to find those values.

[Ace_XL]

Try

=LOOKUP(A1,{"Accident","Failure","Violation"},{1,2,3})
or
=MATCH(A1,{"Accident","Failure","Violation"},0)

[lhansberry]

I am still having trouble entering the information. an error message of N/A is given.

Date Incident Incident CODE Location of Incident Driver Agent
10/1/2013 ACCIDENT

Column A = Date
Column B = Incident ( which will be coded/ A(accident = 1); F(failure to comply = 2); V(violation = 3).
Column C = Incident code
Column D = Location
Column E = Violator
Column F = Agent

I need a formula for columns B & C -
Example:
Accident = 1
Failure = 2
Violation = 3

[Ace_XL]

Try in column C

=LOOKUP(B2,{"A","F","V"},{1,2,3})
or
=MATCH(B2,{"A","F","V"},0)