Use number in a cell in formula

[andonny]

Hi,
I need a formula in B1 to be similar to =F & A1. I have a number 5 in cell A1.

Basically I need =F and use the number 5 from cell A1 to give me the result of =F5.

Thank you for your help
Andonny

 

[Aladin Akyurek]

Hi,
I need a formula in B1 to be similar to =F & A1. I have a number 5 in cell A1.

Basically I need =F and use the number 5 from cell A1 to give me the result of =F5.

Thank you for your help
Andonny

=INDEX(F:F,A1)

 

[macajm]

Or you could try B1=indirect("F"&A1)

 

[Aladin Akyurek]

Or you could try B1=indirect("F"&A1)

Why? Because it's volatile or because you want to lock it to column F forever?

 

[andonny]

I want to lock it to column F forever.

Thanks a million
Andonny