View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NSH NSH is offline
external usenet poster
 
Posts: 1
Default 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?