Index Match

[j4ymf]

Hello
if I can find the ROWS and COLUMNS using MATCH how do I find out what is in the range


<code>=MATCH($O$38,Holidays!$A$4:$A$92,0)</code> returns the row number. result=19
<code>=MATCH($Q$37,Holidays!$A$3:$OE$3,0)</code> returns the Column number result=184

How do I find out what is in column 184 and row 19, which will be GB22. and my result is H

can someone help me write a formula that puts it all together

many thanks Jason

 

[Eric W]

Try:

=INDEX(Holidays!$A$4:$OE$92,MATCH($O$38,Holidays!$A$4:$A$92,0),MATCH($Q$37,Holidays!$A$3:$OE$3,0))

 

[j4ymf]

BISH BASH BOSH
thank you
you are a star

 

[Eric W]

Glad to help!