Hello everyone.

I'm just messing around on Excel, and I wish to use a cell value to be used
in a formula so E.G

B Column is full of random Words (spanner, spoon, stool etc)

Column A1 = 1

I want in Cell C1 to do something like =Sheet1!B & Sheet1!A1

I know the above doesn't work, but it would basically I could change the
number in cell A1 and it would look at a different row in Column B.

I hope that makes sense, thanks in advance.

Note - I was thinking something to do with INDIRECT, but can't seem to get
that right either.

Nate