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