Forum Discussion

Andrianka's avatar
Andrianka
Copper Contributor
Mar 02, 2023
Solved

Drop-down list

Hi everyone) Will be grateful for help)

 

I just start to use Excell and have the next situation -

I need to create a drop-down list in a spreadsheet that will include 3 cells (3 opportunities to choose from). The list that I wanna use is on the next page (List), it includes one column and approx. 50 rows. But I need to see in my drop-down just 3 separate cells.

 

(On the first page I wanna choose layers of coating - base, middle, and top, using a multiple drop-down list and INDIRECT function, that will show me a list of coating that belonges to the base, middle, or top)

At youtube I found a videos, that explains how to do this when base, middle, and top are a separate columns..

 

Many thanks!

 

 

 

Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Mar 02, 2023

    Andrianka 

    Absolute cell reference in a formula, such as $A$1

    in a formula or in a drop down, no matter where it is used.

     

    The difference between absolute, relative and mixed references

    Relative references    A relative cell reference in a formula, such as A1, is based on the relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed. If you copy or fill the formula across rows or down columns, the reference automatically adjusts. By default, new formulas use relative references. For example, if you copy or fill a relative reference in cell B2 to cell B3, it automatically adjusts from =A1 to =A2.

     

    Absolute references    An absolute cell reference in a formula, such as $A$1, always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same. If you copy or fill the formula across rows or down columns, the absolute reference does not adjust. By default, new formulas use relative references, so you may need to switch them to absolute references. For example, if you copy or fill an absolute reference in cell B2 to cell B3, it stays the same in both cells: =$A$1.

     

    Mixed references    A mixed reference has either an absolute column and relative row, or absolute row and relative column. An absolute column reference takes the form $A1, $B1, and so on. An absolute row reference takes the form A$1, B$1, and so on. If the position of the cell that contains the formula changes, the relative reference is changed, and the absolute reference does not change. If you copy or fill the formula across rows or down columns, the relative reference automatically adjusts, and the absolute reference does not adjust. For example, if you copy or fill a mixed reference from cell A2 to B3, it adjusts from =A$1 to =B$1.

     

Resources