Data Validation for planning

[bchappe]

Hello I was wondering if I could get some advice on how to set up this task of mine.

I have a column that I called "Work Task". This column uses a Data Validation list of all the work tasks (85) we use. We use on average 10 work tasks a week. When I select from the work task I want to be able to have the next column reflect the resources needed for that work task. Is there a way to show that in the next column using another Data Validation command, formula, or something else without having to include the resources in the same column of the work task?

Thanks

 

[etaf]

on the data validation list
next to each work task and a column for resources
now you can use a vlookup formula

assuming the list is in Sheet 2 and starts in column A2
and your work task data validation column is on sheet 1 C2
then in D2 put
=vlookup(c2,sheet2!A2:B87,2, false)

=vlookup(

 

[L. Howard]

Hello I was wondering if I could get some advice on how to set up this task of mine.

I have a column that I called "Work Task". This column uses a Data Validation list of all the work tasks (85) we use. We use on average 10 work tasks a week. When I select from the work task I want to be able to have the next column reflect the resources needed for that work task. Is there a way to show that in the next column using another Data Validation command, formula, or something else without having to include the resources in the same column of the work task?

Thanks

Hi bchappe,

I notice you say "resources" as if there may be several.

Is that true? If so, you may want to consider a dependent drop down to offer a selection from, say in the same cell as etaf suggests a VLOOKUP.

Or, it is possible to produce a list of the resources, say there were 7, in the column next to the drop down from which you selected a Work Task.

Howard