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