Filling Out Cells Based on Data Validation

E

Ericc

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?
 
G

Gord Dibben

VLOOKUP or INDEX and MATCH

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top