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