# Double lookup formula

=?Utf-8?B?U3RldmU=?=
Guest
Posts: n/a

 1st Feb 2006
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

=?Utf-8?B?S2V2aW4gVmF1Z2hu?=
Guest
Posts: n/a

 1st Feb 2006
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
>

=?Utf-8?B?U3RldmU=?=
Guest
Posts: n/a

 1st Feb 2006
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
> >

=?Utf-8?B?S2V2aW4gVmF1Z2hu?=
Guest
Posts: n/a

 1st Feb 2006
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
> > >

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Ryan Microsoft Excel Worksheet Functions 8 14th May 2007 09:44 PM vve Microsoft Dot NET Framework 0 14th May 2007 02:13 PM =?Utf-8?B?TVI=?= Microsoft Excel Worksheet Functions 2 10th Mar 2005 02:59 AM Frank Kabel Microsoft Excel Worksheet Functions 1 12th Aug 2004 03:53 PM chocolab61571 Microsoft Excel Misc 1 7th Apr 2004 08:48 AM

Features