Offset formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-1455762%22%20slang%3D%22en-US%22%3EOffset%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455762%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20guys%20I'm%20a%20bit%20stuck%20and%20would%20love%20your%20help!!%3CBR%20%2F%3EI%20need%20a%20formula%20which%20can%20use%20the%20contence%20of%20a%20cell%20as%20the%20cell%20reference%20in%20an%20offset%20formula.%20ie.%20say%20cell%20using%20sheet%202%20below%20by%20referencing%20A1%20I%20want%20to%20get%20the%20answer%20show%20in%20column%20B%20ie.%20Win1%20and%20Win2%2C%20through%20referring%20back%20to%20where%20the%20results%20in%20column%20A%20came%20from%20(sheet%201)%20and%20offesting%20across%202%20columns.%20Thanks%20in%20advance%20for%20any%20guidance!!%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESheet1%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3ED%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3E23%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3EWin1%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3EWin2%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3ESheet%202%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%22188px%22%20height%3D%2230px%22%3EC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3E%3DSheet1!A1%3C%2FTD%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3EWin1%3C%2FTD%3E%3CTD%20width%3D%22188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3E%3DSheet1!B2%3C%2FTD%3E%3CTD%20width%3D%2294px%22%20height%3D%2230px%22%3EWin2%3C%2FTD%3E%3CTD%20width%3D%22188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1455762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455991%22%20slang%3D%22en-US%22%3ERe%3A%20Offset%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696058%22%20target%3D%22_blank%22%3E%40Geeeeee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20-%20is%20this%20what%20you%20want%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457795%22%20slang%3D%22en-US%22%3ERe%3A%20Offset%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457795%22%20slang%3D%22en-US%22%3E%3CP%3E%40%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3Epeteryac60%3C%2FA%3E%3C%2FP%3E%3CDIV%20class%3D%22post-author-login%22%3EThanks%20for%20sending%20that%20through.%20Unfortunately%20it's%20not%20quite%20what%20I%20need.%20I%20have%20updated%20your%20file%2C%20if%20you%20look%20at%20sheet2%20I%20need%20the%20answers%20highlighted%20in%20yellow%26nbsp%3Bto%20show%20win1%20and%20Win2%20through%20referencing%20A4%20and%20A5%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458105%22%20slang%3D%22en-US%22%3ERe%3A%20Offset%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458105%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20solved%20it%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3BThanks%20for%20assisting!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@Geeeeee 

 

See attached - is this what you want?

 

Peter

Highlighted

@peteryac60

Highlighted

I have solved it  @peteryac60 Thanks for assisting!