Hi

i'm still a bit confused, my understanding is ... the labour cost for Doors
& Windows is populated via a VLOOKUP that says something along the lines of
=VLOOKUP(B2,LabourTable,2,0)
and what you want is in column E (for example) the name of the person who is
doing the work ... so where is the name of the person stored currently? in
the LabourTable in column 3? or do you want to have a data validation list
of 5 people and choose from this drop down who is doing the labour on this
job?

(likewise for the materials)

Cheers
JulieD

"MCorrea" wrote in message
...
Hi Julie,

What I have is a spreadsheet with multiple vlookups and data
validations such as:

Column A Column B Column C Column
D
Category Service Description Labor Cost Material
Cost

The Category column is linked to a data validation list where I have a
couple of variables such as Preliminary Services, Doors & Windows,
Concrete,
etc. Column B is an indirect Data Validation link to Column A, so for
instance if I choose Doors & Windows in the category column cell all of
the
tasks related to Doors & Windows will appear in a list for me to choose
one
from. In column. Column C and D have Vlookup functions that give me the
direct cost of labor and materials related to the specific Service
Description choosen. Well, to have the costs of the services is helpful
but I
need to know what to buy and who's doing the labor. So what I need is a
new
indirect data validation that could be located in a separate spreadsheet
that
when I choose Doors & Windows from the list it will specify me what the
materials are and who's the labor. Keep in mind that the data is available
since the costs came up in the cells. I just can't compile them in a new
Data
Validation and Vlookup list.

Thanks,

MCorrea
"JulieD" wrote:

Hi

not sure what you're asking here ... validation checks the entry of data
into a cell, so say we're talking about cell A1, what do you want the
user
to type in cell A1 so that it passes validation?

Cheers
JulieD


"MCorrea" wrote in message
...
Hi,

I'm working with data validation in multiple spreadsheets in a
specific
excel project. My question is:

Is it possible to insert multiple Data Validation criterias for a
single cellin Excel 2003?
Example:

List
=Indirect(categories)

Date
=Today()+7

The combinatio of these two criterias would be the results shown in the
adjacent cell.

Thanks,

MCorrea
Excel 2003