Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with a formula | Excel Worksheet Functions | |||
What formula can I set up to do a cross lookup in an Excel table? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula help (Lookup) | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |