Hi all

I have the following formula which works perfectly, but I'm having problems trying to make it more dynamic...

i.e. the formula arrays used in the index are currently fixed to the worksheet 'ABB Aluminium'

I would like to get this to refer to a cell, say A8, which would have the name of the relevant worksheet in.

=IF(BE8<=55,INDEX('ABB Aluminium'!$B$8:$K$29,MATCH(BE8,'ABB Aluminium'!$B$8:$B$29,0),MATCH(CA8,'ABB Aluminium'!$B$8:$K$8,0)),"-")

I've tried to use INDIRECT, but I can't seem to get it to work...

Thanks in advance