Vlookup - modify dropdown lists

H

Hirsch

I have been issued a new spread sheet which utilizes a vlookup formula:

=VLOOKUP(D113,JobID,2,FALSE)

"JobID" is a cell reference (actually 4 cells on the same row for
consecutive columns)

My goal is to modify or understand how this "JobID" was created. If this is
used in a vlookup does the list start on a specific row and go to the end of
the sheet?

any assistance would be appreciated
 
T

T. Valko

JobID is a named range.

To see what it refers to if it's a static range:

At the far left of the formula bar is the name box (directly above column
A). Click the drop arrow and you should see JobID in the list. Click on
JobID and that named range will be selected.

If JobID is a dynamic range:

Goto the menu Insert>Name>Define
You should see JobID in the list thats presented
Select it and look at the Refers to box. That will show the formula that
defines JobID.
 
H

Hirsch

Valko - you answered my question!!!!

I don't like the function nor do I care for how it was used in my situation,
but I now understand it more.

Thank you so much.

Hirsch
 
Top