Nested IF statements

[daleEH]

Hi There,

I've created this nested IF statement:

=if('Form Responses 1'!C3="1: Strong disagree",1,if('Form Responses 1'!C3="2: Disagree",2,if('Form Responses 1'!C3="3: Slight disagree",3,if('Form Responses 1'!C3="4: Slight agree",4,If('Form Responses 1'!C3="5: Agree",5,if('Form Responses 1'!C3="6: Strong agree",6,0))))))

What I want to do is get the formula to read a number that i enter into a blank cell that represents the row I want the formula to read from and adjust accordingly eg; 'Form Responses 1'!C3 adjusts to 'Form Responses 1'!C6 by entering 6 into a blank cell.

Is this possible?

daleEH

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LEFT(INDEX('Form Responses 1'!C:C,B2),1)

Where B2 is where you type in the row number.

 

[daleEH]

Hi & welcome to MrExcel.
How about

=LEFT(INDEX('Form Responses 1'!C:C,B2),1)

Where B2 is where you type in the row number.

Thanks Fluff,

Brilliant, simple, less formula, achieves the task at hand and i'm a happy individual.

Great value and thanks

 

[Fluff]

You're welcome & thanks for the feedback.