Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup with Noncontinuos Tables
I have a list of construction labor rates that are contained in (5) seperate
tables in which I would like to use the VLookup function. I have yet to figure out how I can use the function with a table that is seprated into (5) sections. It may be that there is no way to use the function in this type of format. Could someone please let me know if it is possible and if so how. Many thanks. JAD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup with Noncontinuos Tables
Why not make a single table of the data on a new worksheet using formulas
like =Sheet1!A1 Then you can use Vlookup The new table will reflect any modifications (not additions/deletions) you make to the original data. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JAD" wrote in message ... I have a list of construction labor rates that are contained in (5) seperate tables in which I would like to use the VLookup function. I have yet to figure out how I can use the function with a table that is seprated into (5) sections. It may be that there is no way to use the function in this type of format. Could someone please let me know if it is possible and if so how. Many thanks. JAD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup with Noncontinuos Tables
Need more details.
Where are the tables? How do you determine which table to use? Biff "JAD" wrote in message ... I have a list of construction labor rates that are contained in (5) seperate tables in which I would like to use the VLookup function. I have yet to figure out how I can use the function with a table that is seprated into (5) sections. It may be that there is no way to use the function in this type of format. Could someone please let me know if it is possible and if so how. Many thanks. JAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on 3 different tables - please HELP | Excel Worksheet Functions | |||
VLookUp Tables | Excel Worksheet Functions | |||
VLOOKUP with TABLES | Excel Discussion (Misc queries) | |||
Vlookup Tables | Excel Worksheet Functions | |||
VLookUp / 2 Tables | Excel Discussion (Misc queries) |