software

I am looking for a formula that when I enter
quot;May-06quot; in A7 and quot;PMquot; in A8, I get quot;test 17quot; 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 1Test 13
2 Feb-06 test 2Test 14
3 Mar-06 test 3Test 15
4 Apr-06 test 4Test 16
5 May-06 test 5Test 17
6
7 May-06
8 PM
9 Test 17

Thanks for any help you can provide. Steve

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,{quot;quot;,quot;AMquot;,quot;PMquot;},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-Proquot;Stevequot; wrote:

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

Try
=INDEX(B2:C6,MATCH(A7,A2:A6),MATCH(A8,B1:C1))
--
Kevin Vaughnquot;Stevequot; wrote:

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

Thanks to both of you for your help , Steve

quot;Kevin Vaughnquot; wrote:

gt; Try
gt; =INDEX(B2:C6,MATCH(A7,A2:A6),MATCH(A8,B1:C1))
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;Stevequot; wrote:
gt;
gt; gt; I am looking for a formula that when I enter
gt; gt; quot;May-06quot; in A7 and quot;PMquot; in A8, I get quot;test 17quot; in A9 as the result from my
gt; gt; table
gt; gt; (i would use some validation and named ranges later)
gt; gt; A B C
gt; gt; AM PM
gt; gt; 1 Jan-06 test 1Test 13
gt; gt; 2 Feb-06 test 2Test 14
gt; gt; 3 Mar-06 test 3Test 15
gt; gt; 4 Apr-06 test 4Test 16
gt; gt; 5 May-06 test 5Test 17
gt; gt; 6
gt; gt; 7 May-06
gt; gt; 8 PM
gt; gt; 9 Test 17
gt; gt;
gt; gt; Thanks for any help you can provide. Steve

You're welcome.
--
Kevin Vaughnquot;Stevequot; wrote:

gt; Thanks to both of you for your help , Steve
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; Try
gt; gt; =INDEX(B2:C6,MATCH(A7,A2:A6),MATCH(A8,B1:C1))
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;Stevequot; wrote:
gt; gt;
gt; gt; gt; I am looking for a formula that when I enter
gt; gt; gt; quot;May-06quot; in A7 and quot;PMquot; in A8, I get quot;test 17quot; in A9 as the result from my
gt; gt; gt; table
gt; gt; gt; (i would use some validation and named ranges later)
gt; gt; gt; A B C
gt; gt; gt; AM PM
gt; gt; gt; 1 Jan-06 test 1Test 13
gt; gt; gt; 2 Feb-06 test 2Test 14
gt; gt; gt; 3 Mar-06 test 3Test 15
gt; gt; gt; 4 Apr-06 test 4Test 16
gt; gt; gt; 5 May-06 test 5Test 17
gt; gt; gt; 6
gt; gt; gt; 7 May-06
gt; gt; gt; 8 PM
gt; gt; gt; 9 Test 17
gt; gt; gt;
gt; gt; gt; Thanks for any help you can provide. Steve