Prev: Text to Columns
Next: Active Workbook
From: HL on 1 Jun 2010 12:59
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?
From: Luke M on 1 Jun 2010 13:45
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.

--
Best Regards,

Luke M
"HL" <HL(a)discussions.microsoft.com> wrote in message
news:1154837E-32F7-479C-9A58-82CCB23A2771(a)microsoft.com...
>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?


 | 
Pages: 1
Prev: Text to Columns
Next: Active Workbook