Hi,

I have two sheet

Sheet1 contains data:

collumn A:
Apple
Banana
Orange
...

Sheet2
in cell A1 is linked to sheet1 A1 so the result is apple

in Cell A2 i need a formula that will locate cell A1 address and then offset it by 1

ideally cell A2 answer will be banana b/c cell A1 Address was sheet 1 Apple.


i tried using a cell(address) function with indirect and offset and couldn't get it to work

any help would be appreciated.

thanks