Posted to microsoft.public.excel.worksheet.functions
|
|
Return Formula
willemeulen wrote:
I put "sheet1" in front of the column number but no results
Now formula in lookup table is as follows:
=INDIRECT("'Sheet1'!M"&ROW())+0.57*INDIRECT("'Shee t1'!N"&ROW())+INDIRECT("'Sheet1'!O"&ROW())-1.75*INDIRECT("'Sheet1'!F"&ROW())
Define "no results".
|