Filling Out Cells Based on Data Validation
 

I have created a drop down list using data validation. What I need to do now
is have cells filled out based on the value selected.

In this case, the list has three values (Cell A1), and I need to have a
range of cells (C7 to C54) populate data based on the specific value in A1.
The other data is on a sheet named "Data Entry."

Is this enough information or would I need to provide more?

Filling Out Cells Based on Data Validation
 

VLOOKUP or INDEX and MATCH

Where are the data to pull over located on Data Entry sheet?


Gord Dibben MS Excel MVP

On Tue, 1 Jun 2010 14:33:01 -0700, Ericc
wrote:

I have created a drop down list using data validation. What I need to do now
is have cells filled out based on the value selected.

In this case, the list has three values (Cell A1), and I need to have a
range of cells (C7 to C54) populate data based on the specific value in A1.
The other data is on a sheet named "Data Entry."

Is this enough information or would I need to provide more?