Count Columns, Return Content

[Leah G]

I need a function to return the contents of a cell based on a number given in
column F. Here it is:

A B C D E F
* $ @ % # 3 (I would need column G to return @ since it's 3
columns over)
^ ! % # * 2 (I would need column G to return ! since it's 2
columns over)

Does this make sense?

 

[Mike H]

Try this in g1

=CHOOSE(F1,A1,B1,C1,D1,E1)

Mike

 

[RagDyeR]

Try this:

=INDEX(A1:E1,F1)

Copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I need a function to return the contents of a cell based on a number given
in
column F. Here it is:

A B C D E F
* $ @ % # 3 (I would need column G to return @ since it's 3
columns over)
^ ! % # * 2 (I would need column G to return ! since it's 2
columns over)

Does this make sense?

 

[Leah G]

That didn't work. Should there be a : somewhere?

 

[Leah G]

This worked! Thanks so much!

 

[Mike H]

That didn't work. Should there be a : somewhere?

It works perfectly and no there shouldn't be a : somewhere

Mike