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?