If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|