Count Columns, Return Content
 

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?

Count Columns, Return Content
 

Try this in g1

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

Mike

"Leah G" wrote:

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?

Count Columns, Return Content
 

Hi Leah,

You could use OFFSET for this

Enter
=OFFSET(A1,0,F1-1,1,1)
in column G

Remember that A1 and F1 in this formula will need to be changed to the
corresponding cells you are working on

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200907/1

Count Columns, Return Content
 

Try this:

=INDEX(A1:E1,F1)

Copy down as needed.
--

HTH,

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


"Leah G" <Leah wrote in message
...
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?

Count Columns, Return Content
 

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

"Mike H" wrote:

Try this in g1

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

Mike

"Leah G" wrote:

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?

Count Columns, Return Content
 

This worked! Thanks so much!

"Alan McQuaid via OfficeKB.com" wrote:

Hi Leah,

You could use OFFSET for this

Enter
=OFFSET(A1,0,F1-1,1,1)
in column G

Remember that A1 and F1 in this formula will need to be changed to the
corresponding cells you are working on

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200907/1

Count Columns, Return Content
 

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

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

Mike

"Leah G" wrote:

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

"Mike H" wrote:

Try this in g1

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

Mike

"Leah G" wrote:

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?