Sheet1
A1: Football
A2: Rugby
A3: Basketball
Sheet2:
A1: A2
A2: B4
How can I get a location of a field from String? Is it even possible?
eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'