M
Mike B
Hi,
I am trying to get the following working using the lookup function. it works
fine as it is shown however I have tried entering the lookup function
referencing it from cell 'A5' but cant get it to work. Can anyone help by
showing me the correct method.
Thanks
Mike
=INDEX('12'!$B$2:$R$47,MATCH($D$1,'12'!$A$2:$A$47,0),MATCH(1,IF('12'!$B$2:$R$2=$D$6,IF('12'!$B$4:$R$4=$A$3,1)),0))
I am trying to get the following working using the lookup function. it works
fine as it is shown however I have tried entering the lookup function
referencing it from cell 'A5' but cant get it to work. Can anyone help by
showing me the correct method.
Thanks
Mike
=INDEX('12'!$B$2:$R$47,MATCH($D$1,'12'!$A$2:$A$47,0),MATCH(1,IF('12'!$B$2:$R$2=$D$6,IF('12'!$B$4:$R$4=$A$3,1)),0))