Example- Varying row number.
If I need to look up cell A(x) where,
A is the column alphabet.
x is the variable row number.
How can I input x as a variable?

OR

Example- Varying column alphabet.
If I need to look up cell (x)1 where,
x is the variable column alphabet.
1 is the row number.
How can I input x as a variable?

Thank you