First of all the dropdown list is created using Data Validation, not CF.

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Fri, 28 Sep 2007 17:18:02 -0700, Brad wrote:

I have some cells you can select using a dropdown list using conditional
formatting, and I want to be able to populae the next cell depending on what
was selected but I don't know how to do it.

For example, if 1 is selected on cell A1 on the dropdown list, I want cell
B1 to automatically fill in ONE based on another list in the same workbook on
a different sheet...But I don't know how to do this - can anyone help me out
here? Thanks.