Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple
Good afternoon,
I have created a drop down pick list for a Phase from a table named "Phase" in Column A. (works great) I need to create a drop down pick list for a code in Column B related to the phase in column B. I tried =VLOOKUP(A3,PK_OPERATE!A2:B299,Phase) . Due to each Phase having more than one code related errors #N/A #REF. Do I need to do an if statement with the Vlookup? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple
I tried =VLOOKUP(A3,PK_OPERATE!A2:B299,Phase) . Due to each Phase having more than one code related errors #N/A #REF. Do I need to do an if statement with the Vlookup? Doesn't the 3rd argument need to be a number or reference that returns a simple number? You have "Phase" in the formula, which is the name of a large area, I take it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a dropdown list to select multiple items | Excel Worksheet Functions | |||
pick from dropdown list | Excel Discussion (Misc queries) | |||
how to create multiple hyperlinks within a dropdown list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions |