Prev: how can we make one constant number to be act as variable
Next: Remove columns with all zeros
From: Ericc on 1 Jun 2010 17:33
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?
From: Gord Dibben on 1 Jun 2010 18:15
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 <Ericc(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: how can we make one constant number to be act as variable
Next: Remove columns with all zeros