Parse input and auto-replace

I would like to set up a chart of values like so:

..| X| Y| Z|
------------
1|...|...|...|
2|...|...|...|
3|...|...|...|
4|...|...|...|
5|...|...|...|


And then, in another area of the spreadsheet, I would like to be able to type in values quickly in shorthand based on the chart coordinates ("3z" or "4y") and have Excel auto-replace my input with the value in that box of the chart. Ideally I'd like the auto-replace to be nondestructive (I could view it in the "4x" format again later if I wanted). Is there a way to do this? (also, is there a way to do this with 3 coordinates?)

(The values in the chart don't follow a pattern and the x, y, and z are not variables, just headings).

Thanks