Offset formula help

Copper Contributor

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

ABCD
23 Win1 
 25 Win2

Sheet 2

ABC
=Sheet1!A1Win1 
=Sheet1!B2Win2 
3 Replies

@Geeeeee 

 

See attached - is this what you want?

 

Peter

@peteryac60

I have solved it  @peteryac60 Thanks for assisting!