formula that will reference another worksheets info. same book
 

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

formula that will reference another worksheets info. same book
 

Can you be more specific?

--JP

On Aug 11, 2:51*pm, Jeff Wood <Jeff
wrote:
I want to write a formula that will reference info on another worksheet
within the same workbook

formula that will reference another worksheets info. same book
 

Jeff Wood wrote:
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.

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

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

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

formula that will reference another worksheets info. same book
 

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'!B3 1))),0,-1)
--
GHD


"Jeff Wood" wrote:

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