Instead of nested IF statements - Simple question

[Dart180]

Hello!

I want to return data from a certain column based on an IF statement.

It is very simple but I have 200+ columns of data so I can not use multiple IF statements.

See the attached picture for the best explanation.

Picture: https://imgur.com/a/Q5yzg

How can I solve this?

Thanks for you'r support guys!

 

[Aladin Akyurek]

Try to post a small sample (instead of an image or a link to an image) along with the expected results.

 

[Dart180]

Could not find a way to attach the document but I will write the current solution here:

=IF(A1=1,B1, IF(A1=2,C1, IF(A1=3,D1....

Basically, I want to type in the name/nr of the column and return its value.

 

[Aladin Akyurek]

Could not find a way to attach the document but I will write the current solution here:

=IF(A1=1,B1, IF(A1=2,C1, IF(A1=3,D1....

Basically, I want to type in the name/nr of the column and return its value.

Is this what you need?

=INDEX($B$1:$Z$1,$A1)