I need help on cell reference please

[Maple]

Here is my problem

I have data in columns a, b and c which is data for each month (Jan, Feb March)

I have another cell let's say in d1 that holds a number equal to a particular month ( 1 for Jan, 2 for feb 3 for march)

What I need to do is - show in column e the data that is from column a or b or c depending on the value of d1. I am trying to do this with a cell formula instead of a vlookup as I can't add a reference column for the vlookup because I am working with spreadsheets that are linked based on cell references and I don't want to disturb that, if possible.

One other thing I have to deal with 12 months this way and am told I can't use an if statement holding 12 ifs)


Thanks

 

[Aladin Akyurek]

Here is my problem

I have data in columns a, b and c which is data for each month (Jan, Feb March)

I have another cell let's say in d1 that holds a number equal to a particular month ( 1 for Jan, 2 for feb 3 for march)

What I need to do is - show in column e the data that is from column a or b or c depending on the value of d1. I am trying to do this with a cell formula instead of a vlookup as I can't add a reference column for the vlookup because I am working with spreadsheets that are linked based on cell references and I don't want to disturb that, if possible.

One other thing I have to deal with 12 months this way and am told I can't use an if statement holding 12 ifs)


Thanks

Maybe...

=INDEX(A1:C1,D1)