List as Range
 

I am loading multiple sheets with external data. I am going to load each set
of data into a different "List". I would like to use the List as a range in
other functions, ie use the Vlookup to scan the List.

Anyone familiar with how to set a Range equal to a List?

List as Range
 

Are you asking how to use it in a worksheet formula or how to set the range
equal to the range a name refers to in VB?

For worksheet (or even VB) you are going to start by defining the named
range. Lets say your table goes from cell A1 over and down to D100. Select
cells A1:D100 and enter a name for the list into the Name Box (the place
where the address of the currently selected cell is usually shown - just
above the "A" column indicator). Type in a name for the selected cells as
maybe MyLookupTable. Press the [Enter] key - important step, don't skip it.

Then in a VLOOKUP formula in the workbook you could use it in this fashion:
=VLOOKUP(X4,MyLookupTable,4,False)
same as writing
=VLOOKUP(X4,Sheetn!A1:D100,4,False)

Does that help any?

"Troubled User" wrote:

I am loading multiple sheets with external data. I am going to load each set
of data into a different "List". I would like to use the List as a range in
other functions, ie use the Vlookup to scan the List.

Anyone familiar with how to set a Range equal to a List?