Return Contents of Cell Based on Column Number

[ellison]

Hi, we are trying to duplicate the contents of a cell (from the same row) based on the column number which has been chosen.

i.e. the raw data in Columns D to H has been reviewed, and the "Chosen Column" to use has been put in Col C.

And somehow we would like our "Goal" in Col B to duplicate the contents of the cell which has been selected.

Return-Cell-Contents-Based-On-Column-Number-01.xlsx
	A	B	C	D	E	F	G	H
1	Row Number	Goal	Chosen Column From D to H	D	E	F	G	H
2	2	I	1	I	will	not	be	chosen
3	3	99	3	sometimes	numbers	99
4	4	Case	4	Upper	And	LOWER	Case
5	5	blanks	5	there		are		blanks
6	6	goal	1	goal
Sheet1

Cell Formulas
Range	Formula
A2:A6	A2	=ROW()

I got myself totally lost trying to look at offsets, matches and indexes

Please could somebody take a look?

 

[etaf]

try
=CHOOSECOLS(D2:H2,C2)

Book5
	A	B	C	D	E	F	G	H	I	J
1	Row Number	Goal	Chosen Column From D to H	D	E	F	G	H
2	2	I	1	I	will	not	be	chosen		I
3	3	99	3	sometimes	numbers	99				99
4	4	Case	4	Upper	And	LOWER	Case			Case
5	5	blanks	5	there		are		blanks		blanks
6	6	goal	1	goal						goal
Sheet1

Cell Formulas
Range	Formula
A2:A6	A2	=ROW()
B2:B6	B2	=CHOOSECOLS(D2:H2,C2)
J2:J6	J2	=CHOOSECOLS(D2:H2,C2)

 

[Fluff]

Another option

=INDEX(D2:H2,,C2)

 

[ellison]

Both a re excellent options, HUGE thanks to you both!!

 

[etaf]

you are welcome

 

[Fluff]

Glad we could help & thanks for the feedback.