double lookup

[cucaracha]

Dear all,

I am trying to do a double lookup on the following table:
The range of the table is B2:I50

HORA DOM SEG TER QUA QUI SEX SAB
0:00 V V FV FV FV FV FV
0:30 V V V V V V V
1:00 V V V V V V V
1:30 V V V V V V V
2:00 V V V V V V V
2:30 V V V V V V V
3:00 V V V V V V V
3:30 V V V V V V V
4:00 V V V V V V V
4:30 V V V V V V V
5:00 V V V V V V V
5:30 V V V V V V V
6:00 V V V V V V V
6:30 V V V V V V V
7:00 V V V V V V V
7:30 V FV FV FV FV FV V
8:00 V FV FV FV FV FV V
8:30 V FV FV FV FV FV V
9:00 V FV FV FV FV FV V
9:30 V FV FV FV FV FV V
10:00 V FV FV FV FV FV FV
10:30 V FV FV FV FV FV FV
11:00 V FV FV FV FV FV FV
11:30 V FV FV FV FV FV FV
12:00 V FV FV FV FV FV FV
12:30 V FV FV FV FV FV FV
13:00 V FV FV FV FV FV FV
13:30 V FV FV FV FV FV V
14:00 V FV FV FV FV FV V
14:30 V FV FV FV FV FV V
15:00 V FV FV FV FV FV V
15:30 V FV FV FV FV FV V
16:00 V FV FV FV FV FV V
16:30 V FV FV FV FV FV V
17:00 V FV FV FV FV FV V
17:30 V FV FV FV FV FV V
18:00 V FV FV FV FV FV V
18:30 V FV FV FV FV FV V
19:00 V FV FV FV FV FV FV
19:30 V FV FV FV FV FV FV
20:00 V FV FV FV FV FV FV
20:30 V FV FV FV FV FV FV
21:00 V FV FV FV FV FV FV
21:30 V FV FV FV FV FV FV
22:00 V FV FV FV FV FV FV
22:30 V FV FV FV FV FV V
23:00 V FV FV FV FV FV V
23:30 V FV FV FV FV FV V

and on cell L2 I put the hour and on L3 I put the day. On L4 should give the result. for instance on 04:30 of SAB the result should be V.
I am writing the following array formula but is giving me an error:
=OFFSET(B2:I50;MATCH(L2;OFFSET(B2:I50;0;0;ROWS(B2:I50);1);0)-1;MATCH(L3;OFFSET(B2:I50;0;0;1;COLUMNS(B2:I50));0)-1)

Can someone give me some help?
I am using EXCEL 2003.
Best regards,
Cucaracha

 

[anglais428]

are you confirming with CTRL SHIFT ENTER?

 

[cucaracha]

Dear all,

After study problem solved.
The problem was the way that the hour was defined on HORA column

Thank you

Best regards,
cucaracha

 

[VoG]

are you confirming with CTRL SHIFT ENTER?

That formula doesn't require CTRL + Shift + Enter.