Thread: Return Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willemeulen[_6_] willemeulen[_6_] is offline
external usenet poster
  
Posts: 1
Default Return Formula

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())




--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96571

Reply With QuoteReply With Quote