Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement or VLOOKUP
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement or VLOOKUP
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If & Vlookup statement | Excel Worksheet Functions | |||
Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
Not sure whether to use VLOOKUP or an IF statement | Excel Worksheet Functions | |||
If Statement with VLookup | Excel Worksheet Functions | |||
Vlookup or If statement Help | Excel Worksheet Functions |