How can i add/improve this to excel?

[wndncg]

This is the code (formula): ='2024'!$B$1

2024=IS THE SHEET
B is the column
1 is the row

I want 1 will base on the data on cell A1

 

[awoohaw]

What is in cell A1? Is it a number or a formula? Please provide more detail to your scenario.

 

[wndncg]

What is in cell A1? Is it a number or a formula? Please provide more detail to your scenario.

just a regular inputted data sir. example: 1

 

[awoohaw]

Not sure what you want, exactly. But, maybe this works:

Book1
	A	B	C
1	7	Test
2
3
4
5
6
7		Test
8
9
Sheet3

Cell Formulas
Range	Formula
B1	B1	=INDIRECT("B"&A1)

 

[bebo021999]

May be try:

=INDIRECT("'2024'!B" & A1)

 

[wndncg]

Thanks for the reply sir, to give you a visual explanation:

image 1=See Column F row 1 (i want on the code if what i added data on that column reflects on the code)
image 2=the output (sample output for reference is column F row 3)

 

[wndncg]

add:

pic 1 is sheet (2024)
pic 2 is sheet (Sheet1)

the code will be pasted at Sheet1

 

[FormR]

Hi, looks like this to me:

=INDEX('2024'!F3:F1000,'2024'!F1)

 

[wndncg]

Hi, looks like this to me:

=INDEX('2024'!F3:F1000,'2024'!F1)

Working thanks. Mods please close.