IF Statement or VLOOKUP

  • Thread starter Thread starter HL
  • Start date Start date
H

HL

I don't know if I should use an IF statement or VLOOKUP but but i would like
to do the following:
IF A2=0073 THEN B2 = Sales
IF A3 = 0083 THEN B3 = District

Column A will contain information like: 0082, 0092, 0073, etc. Column B is
empty right now but i want to use a formula to insert the ID name based on
the ID listed in column A.

How do i do this?
 
Assuming you have a table somewhere defining which code goes with which
label, you'll want to use:
=VLOOKUP(A2,Your_Table,2,FALSE)

The 3rd arguement defines which column within Your_Table to return (I'm
assuming you're using a 2-column wide table), and the 4th arguement tells
the function you want to find an exact match.
 
Back
Top