Lookup Problem with Index and Match
 

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

Lookup Problem with Index and Match
 

Where would the A5 fit in Mike, the sheet name or one of the values being
compared?

--
__________________________________
HTH

Bob

"Mike B" wrote in message
...
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))

Lookup Problem with Index and Match
 

Mike i believe you need to use this in A5
=*VLOOKUP*($B$1,*INDIRECT*($A$1),2,FALSE) assuming your =INDEX.....etc
is in A1.

Mike B;308659 Wrote:
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))


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

Lookup Problem with Index and Match
 

Hi
on my example I am looking up worksheet '12' 'A5' is the cell where I will
enter the worksheet number i want to Look up

Thanks
Mike

"Bob Phillips" wrote:

Where would the A5 fit in Mike, the sheet name or one of the values being
compared?

--
__________________________________
HTH

Bob

"Mike B" wrote in message
...
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))