Count Columns, Return Content

  • Thread starter Thread starter Leah G
  • Start date Start date
L

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?
 
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?
 
Back
Top