modify drop down table associated to vlookup

H

Hirsch

I've been given a vlookup formula, that is associated with some drop down
list... The formula is:

=VLOOKUP(D113,JobID,2,FALSE)

when I go into the name box or the area that would dictate which cell is
active the "JobID" is available as a drop down.

After clicking on "JobID" 4 cells are highlighted in one row / 4 consecutive
columns.

This is new to me, how can I modify what area is associated with the "JobID"
list? Does this List start at a specific row and goto the bottom of the
spread sheet.

any assistants would be appreciated.
 

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

Drop down list control value in vba 2
Vlookup - modify dropdown lists 3
Move Drop Down List to the Top of the Cell 0
dependent, multiple variable, drop down list 2
Advanced Drop Down List Option 0
Formatted cell column in drop down list 1
Help with using vlookup and acting on the results 2
Use word to associate an item in validation drop down list 2

Top