HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple

N

NSH

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?
 
S

Spiky

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?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Vlookup and MAX functions 4
why this strange result with vlookup 2
How do I create a drop down box within a drop down box? 1
Vlookup 4
validation drop down list question 1
vlookup returning a value in more than one cell 16
can I create a drop down list to pick a date ? 3
How do I reference a "range" for a specific table_array in VLOOKUP 3

Top