Cell variable in formula

[Guest]

Can I use a cell value as a variable in a formula to bring in a cell content


Cell value Cell Content Desired output
A1=5 B5=house C1=house
A2=10 B10=car C2=car
A3=15 B15=truck C3=truck
A4=20 B20=9 C4=9

I tried as a formula in cell C1 =A(b5) but it didn't work, is
there some formula that I can use if I have >500 rows of data without typing
in the actual formula in cell C1

 

[vezerid]

In C1:
=INDIRECT("B"&A1)

HTH
Kostis Vezerides