Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve
 
Posts: n/a
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup with a formula Bren Excel Worksheet Functions 0 December 20th 05 05:14 AM
What formula can I set up to do a cross lookup in an Excel table? grigorovag Excel Worksheet Functions 1 November 28th 05 02:42 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Formula help (Lookup) Ola Sigurdh Excel Discussion (Misc queries) 6 September 7th 05 01:14 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"