Double lookup formula

[Guest]

I am looking for a formula that when I enter
"May-06" in A7 and "PM" in A8, I get "test 17" in A9 as the result from my
table
(i would use some validation and named ranges later)
A B C
AM PM
1 Jan-06 test 1 Test 13
2 Feb-06 test 2 Test 14
3 Mar-06 test 3 Test 15
4 Apr-06 test 4 Test 16
5 May-06 test 5 Test 17
6
7 May-06
8 PM
9 Test 17

Thanks for any help you can provide. Steve

 

[Guest]

Try
=INDEX(B2:C6,MATCH(A7,A2:A6),MATCH(A8,B1:C1))

 

[Guest]

Thanks to both of you for your help , Steve

Try
=INDEX(B2:C6,MATCH(A7,A2:A6),MATCH(A8,B1:C1))

 

[Guest]

You're welcome.
--
Kevin Vaughn

Thanks to both of you for your help , Steve