Offset formula help

Question

Hi guys I'm a bit stuck and would love your help!!
I need a formula which can use the contence of a cell as the cell reference in an offset formula. ie. say cell using sheet 2 below by referencing A1 I want to get the answer show in column B ie. Win1 and Win2, through referring back to where the results in column A came from (sheet 1) and offesting across 2 columns. Thanks in advance for any guidance!!

Sheet1

A	B	C	D
23		Win1
	25		Win2

Sheet 2

A	B	C
=Sheet1!A1	Win1
=Sheet1!B2	Win2

peteryac60 · Answer

Geeeeee&nbsp;&nbsp;See attached - is this what you want?&nbsp;Peter

geeeeee · Answer

@peteryac60Thanks for sending that through. Unfortunately it's not quite what I need. I have updated your file, if you look at sheet2 I need the answers highlighted in yellow&nbsp;to show win1 and Win2 through referencing A4 and A5

geeeeee · Answer

I have solved it&nbsp;&nbsp;peteryac60&nbsp;Thanks for assisting!&nbsp;&nbsp;

Forum Discussion

Offset formula help

3 Replies

Resources