Is there a way to ask excel to give the first or second or... value from the list?

[Meko1]

Hello
I am interested if there is a way excel to give me the 1st value or the text which is in the list or a column.
As in this example First to be blue. 2nd red 5th yellow and so on.

Thank you in advance

sample problem.xlsx
	A	B	C	D	E	F
1
2			give me 1st value from the color List, or A column	give me 2nd	give me 5th
3	blue
4	red
5	green
6	black
7	orange
8	brown
9	yellow
10
11
Sheet1

 

[alansidman]

Book1
	A	B	C	D	E	F
2				1	2	5
3	1	blue		blue	red	orange
4	2	red
5	3	green
6	4	black
7	5	orange
8	6	brown
9	7	yellow
Sheet1

Cell Formulas
Range	Formula
D3:F3	D3	=VLOOKUP(D2,$A$3:$B$9,2,FALSE)

 

[Meko1]

Great Thank you

 

[Herakles]

If you do not want to insert a column containing the position of each colour in the list then you can use the OFFSET function.

=OFFSET($A$1,1,0,1,1) where the second argument is the index number of the colour you want.