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

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

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