Hello all (newbie here, so I hope I am doing this correct)

I have been scratching my head trying to find the best way of solving a
problem I have within a complicated spreadsheet.
In summary I am trying to use two changable lookup values on a different
worksheet within my XLS file.

Looking around and doing research I believe I have found an answer to my
query here :
http://office.microsoft.com/en-us/ex...CL100570551033
showing the use of two new functions to me (Match & Index).

Mimicking and adapting the finalised formala to suit my application i have :

=INDEX(Gross!$A$3:$AR$241,MATCH($C8,Gross!A$2:A$24 0,0),MATCH(I$1,Gross!B$1:AR$1,0))

Gross being a Sheet within the same Excel file, Column A (A2 to A240) having
one of my reference criteria a simple four digit number in the current sheet
in cell C8, and row 1 (B1 to AR1) having my other criteria in date format,
in the current sheet cell I1

As it happens the formula returns the value below the value of C8 in column
A of the sheet Gross.

Do the Functions Match and Index work across different worksheets to where
the formula is ?
Is this explained clearly enough for helping me ?

Thanks in advance.