Brad,

Assuming, you have the data to be selected (when drop down list is operated)
is in Sheet 2, say in range D3:D7. The data based on which you have created
the drop down list, let us assume, are in range B4:B8 of Sheet 1. Then,

in the cell next to the drop down list ( on Sheet 1), type the following and
try:

=INDEX(Sheet2!D3:D7,MATCH(Sheet1!D3,Sheet1!B4:B8,0 ))

If A1 is going to have only Serial Nos., say 1-5 or 1-10 and so on,
representing the row numbers of the range in sheet 2 and you are required to
retrieve data in the same order, you can simply type A1 in place of
Match(Sheet1!B4:B8,0), as the number will serve as the row number for the
Index function.

Best Wishes





"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.