Reference cell defined by value in another cell

[kbka]

Hi!

How do I type a formula where the reference cell is found in another cell so to speak?

For example
column A contains a bunch of number, lets say (a1,a2,a3)=(1,3,9)
Column B contains letters, lets say (b1, b2, b3) = (x,y,z)
Column X, Y and Z contains data.
In column C I want to find data refenced by the given column in B and the row in A. that is

C1: =x1
C2: =y3
C3: =z9

any help is very much appreciated,

kbka

[lmvk99]

Try:

=INDIRECT(B1&A1)

Good Luck!

[kbka]

Workes like a charm! thank you