Vlookup - modify dropdown lists
 

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

Vlookup - modify dropdown lists
 

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 InsertNameDefine
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.



--
Biff
Microsoft Excel MVP


"Hirsch" wrote in message
...
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

Vlookup - modify dropdown lists
 

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

"T. Valko" wrote:

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 InsertNameDefine
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.



--
Biff
Microsoft Excel MVP


"Hirsch" wrote in message
...
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

Vlookup - modify dropdown lists
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hirsch" wrote in message
...
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

"T. Valko" wrote:

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 InsertNameDefine
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.



--
Biff
Microsoft Excel MVP


"Hirsch" wrote in message
...
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