I constructed a lookup table with formula's on the second sheet which I
want to use to return a working formula on sheet 1.

Example Shape Code 39:

Formula (as in the book)
A + 0.57 B + C -1.57d

Value's A,B and C are user defined and can be found on sheet 1 in the
columns M,N and O
d= is the diameter and is user defined in column F


In my lookup table I have the following formula (sheet 2)

INDIRECT("M"&ROW())+0.57*INDIRECT("N"&ROW())+INDIR ECT("O"&ROW())-1.75*INDIRECT("F"&ROW())

What do I need to do to get this cell working on sheet 1
Now it eiter returns the text (when = sign is left out) or returns the
result from sheet two

Thanks,

W


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