IsaacMessi10 0 Junior Poster in Training

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.