Assuming that A1:F5 contains the table, H2 contains Mon, I2 contains B,
and J2 contains 3, try the following formula that needs to be confirmed
with CONTROL+SHIFT+ENTER...

=INDEX($B$2:$F$5,MATCH(J2,$A$2:$A$5,0),MATCH(1,IF( $B$1:$F$1=H2,IF($B$2:$F
$2=I2,1)),0))

Hope this helps!

In article ,
Mike B wrote:

Hi,
I would be gratefull for any help with the following

Mon Mon Tues Tues Wd
1 A B A B A
2 dave Harry Nick Ed Jack
3 Mark Ian Mike Pete Tom
4 Ian Dave Marc Harry Edd

How would I lookup /Match the top two rows and 1st column to return a result
from the names. ie Mon, B,3, Would give me the name Ian.


Thanks
Mike B