Inserting List in IF function

**pseudocode** · 03-29-2007, 07:24 AM

I have the following situation:

In one column i have a list in every cel, this list is fix it is the same in every cel.
In the next column i need excel to insert a list (created on another sheet) depending on the selection from the first column. (i dont know how else to explain).

The formula (or function or whatever) should be something like this:

IF B2="Project1" than C2="List1" -

so if i selected project1 in cel B2 i want excel to insert List1 (the whole list) in the cel C2.

I tried IF (B2="Project1";C2="List") - but it only inserts a value from the "List" it doesn't insert the whole list.

PLEASE HELP

**NBVC** · 03-29-2007, 07:56 AM

Do you mean you want a drop down list?

**pseudocode** · 03-29-2007, 08:11 AM

In one sheet i have one list from which someone selects lets say: 1. Project.
and now i want excel to insert (automatically) a (already existing) list from another sheet into the cel.

Cel B2 Cel C2

-in cel B2 i have
a list and when someone
selects something
i need excel to insert
a list (from another sheet,or
the same sheet) into cel C2

**NBVC** · 03-29-2007, 08:20 AM

I am assuming, then that these are drop down type lists.

Start by naming each of the ranges that represents individual lists. This you do by selecting each range one at a time and going to Insert|Name|Define and entering a name matching an item in the original list (in B2).

Then in C2 go to Data|Validation and select list. In the source field enter formula =Indirect(B2)

So when someone select an item in B2, then C2 will automatically populate with a list with the same name as the item selected in B2.

Hope this is what you're after/.