Combine Cell Contents with a Named Range

[barnett2000]

Hi, there. I have a cell with a drop-down menu where the user can select "Plant A" or "Plant B".

I have a cell below that with a sales number, which comes from a different tab where the sales number is input and has a named range.

For example, the input tab has a named range called "Plant A Sales" and a value of 1234, and a named range called "Plant B Sales" with a value of 5678.

I want to put a formula in a cell that will look at the cell where the drop-down menu is and will populate that cell with the correct data for the selected plant.

So if the user selects "Plant A" from the drop-down menu, the cell will show "1234". If they then select "Plant B" from the drop-down menu, the cell will show "5678".

Thanks for your help!

David

 

[barnett2000]

=INDIRECT() was the function I was looking for.

Hi, there. I have a cell with a drop-down menu where the user can select "Plant A" or "Plant B".

I have a cell below that with a sales number, which comes from a different tab where the sales number is input and has a named range.

For example, the input tab has a named range called "Plant A Sales" and a value of 1234, and a named range called "Plant B Sales" with a value of 5678.

I want to put a formula in a cell that will look at the cell where the drop-down menu is and will populate that cell with the correct data for the selected plant.

So if the user selects "Plant A" from the drop-down menu, the cell will show "1234". If they then select "Plant B" from the drop-down menu, the cell will show "5678".

Thanks for your help!

David