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 |
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 |