Willemeulen, why not attach a sample workbook that we can help you with?
Attatchments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attatchments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.

willemeulen;346398 Wrote:
For some reason it looks like the indirect function does not work on my
sheet. The only way I can get things working is by creating a Hlookup
table which contains the formula for all possible shape files and direct
references to sheet 1. It's not realy pleasing to look at but yeah, any
suggestion how to make it work better.

Intended setup:
Vlookup table

A B
Shape Code Formula
20 =Indirect(sheet1M&row .......
31
32
35
39

etc

Because the lookup function returns a value and not the actual formula
answers will only be correct if row is corresponding between sheet 1 and
2.


New Hlookup table

A B C D
Shape Code 20 30 31 32 etc
11 =sheet1!M11*N11-O11 etc
12
13
14
15
16
corresponding row number with sheet 1

Now I have a big table with exact formulas in the corresponding row, is
this the way to do it or is it a bit duh:ill


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96571