Hi All
I'm using this
=INDIRECT(K6&"!"&I6)
to fetch the cell content from I6 on the named worksheet
Can someone advise as to how the formula can be modified to bring the content firstly from the left of the target cell , and then from the right of it? in this case it would return the content in H6 or J6 from the target worksheet.
I'm trying to build it into a larger formula where if H6 on the current worksheet contains the letter 'F' then it would show content from the cell to the right of the formula above. If H6 contains the letter 'G' then it would show the content to the left of the formula above.
Grateful for any help.
Bookmarks