formula that will reference another worksheets info. same book

[Jeff Wood]

I want to write a formula that will reference info on another worksheet
within the same workbook

 

[JP]

Can you be more specific?

--JP

 

[Glenn]

I want to write a formula that will reference info on another worksheet
within the same workbook

Try "Create a reference between cells on the same or different worksheets" in
the help file.

 

[David McRitchie]

"Jeff Wood" ...

I want to write a formula that will reference info on another worksheet
within the same workbook

Hi Jeff,

=MyFormula(sheet1!B3)
=MyFormula('sheet two'!B3)

Information on some formulas
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm

How to install a Function or Macro
Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[GuyHD]

An example of a formula that addresses another worksheet to find a value in
an array and then selects the corresponding value in a previous column. Kind
of a reverse Vlookup. For your problem, notice the nomenclature for
addressing a cell in another worksheet

=OFFSET(INDIRECT("'worksheetname'!" &
ADDRESS(MATCH(E32,'worksheetname'!B31:B41)
+ROW(worksheetname'!B30),COLUMN('worksheetname'!B31))),0,-1)