Double lookup formula

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Variable Lookup/Double Lookup	Ryan	Microsoft Excel Worksheet Functions	8	14th May 2007 09:44 PM
'System.ArithmeticException was unhandled' at System.Double.CompareTo(Double value) when comparing with Double.NaN	vve	Microsoft Dot NET Framework	0	14th May 2007 02:13 PM
Lookup Lookup Lookup	=?Utf-8?B?TVI=?=	Microsoft Excel Worksheet Functions	2	10th Mar 2005 02:59 AM
Double lookup formula	Frank Kabel	Microsoft Excel Worksheet Functions	1	12th Aug 2004 03:53 PM
help with lookup formula (sheet 2, not a double post)	chocolab61571	Microsoft Excel Misc	1	7th Apr 2004 08:48 AM