Formula / Cell Reference Help!

%3CLINGO-SUB%20id%3D%22lingo-sub-3370984%22%20slang%3D%22en-US%22%3EFormula%20%2F%20Cell%20Reference%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3370984%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20cell%2C%20B23%2C%20that%20is%20the%20reference%20cell%20involved%20in%20many%20formulas%20(a%20blank%20cell%20waiting%20for%20an%20input%20value%20to%20be%20placed%20in%20it%20and%20it%20produces%20an%20answer%20in%20cell%20B38).%20I%20have%20several%20cells%20in%20other%20sheets%20that%20I%20want%20to%20place%20into%20cell%20B23%20to%20retrieve%20answers%20(i.e.%20if%20B23%20%3D%20O39%2C%20what%20will%20B38%20produce%3F%20if%20B23%20%3D%20O40%2C%20what%20will%20B38%20produce%3F%20etc.%20etc.).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20do%20this%20using%20a%20formula%20or%20some%20kind%20of%20technique%3F%20Any%20assistance%20would%20be%20greatly%20appreciated!%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E--%3C%2FP%3E%3CP%3ESteven%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3370984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%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-3371286%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20%2F%20Cell%20Reference%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1389576%22%20target%3D%22_blank%22%3E%40SGMoran%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20a%20data%20table%20for%20this.%20See%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2018%2F10%2F24%2Fdata-table-excel-one-variable-two-variable%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHow%20to%20make%20and%20use%20a%20data%20table%20in%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fdata-tables.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EData%20Tables%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a cell, B23, that is the reference cell involved in many formulas (a blank cell waiting for an input value to be placed in it and it produces an answer in cell B38). I have several cells in other sheets that I want to place into cell B23 to retrieve answers (i.e. if B23 = O39, what will B38 produce? if B23 = O40, what will B38 produce? etc. etc.).

 

Is there a way I can do this using a formula or some kind of technique? Any assistance would be greatly appreciated! Thanks!

 

--

Steven

1 Reply

@SGMoran 

You can use a data table for this. See:

How to make and use a data table in Excel 

Data Tables