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'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.