Double lookup formula
 

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

Double lookup formula
 

Try something like this:

Assumptions:
Col_A contains dates
Your data in Cells A1:C6,
B1: AM,
C1: PM

A8: May-06
A9: PM
A10: =VLOOKUP(A8,A1:C6,MATCH(A9,{"","AM","PM"},0),0)
OR
A10: =VLOOKUP(A8,A1:C6,MATCH(A9,A1:C1,0),0)

Change references to suit your situation.

Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Steve" wrote:

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

Double lookup formula
 

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


"Steve" wrote:

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

Double lookup formula
 

Thanks to both of you for your help , Steve

"Kevin Vaughn" wrote:

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


"Steve" wrote:

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

Double lookup formula
 

You're welcome.
--
Kevin Vaughn


"Steve" wrote:

Thanks to both of you for your help , Steve

"Kevin Vaughn" wrote:

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


"Steve" wrote:

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