Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Dates to Number
I have the following list in AC3:AD11
Qtr Ago Date 8 6/30/2004 7 9/30/2004 6 12/31/2004 5 3/31/2005 4 6/30/2005 3 9/30/2005 2 12/31/2005 1 3/31/2006 In Column AA, rows 1000+, I have numbers randomly dispersed 1 through 8. In Column AC, I would like to return the proper date correpsonding to each number. How do I do this? I can't/don't want to use nested if statements. I supsect the best way is via a defined name? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Dates to Number
looks like a simple vlookup works... thanks
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Dates to Number
Hi
AB3=VLOOKUP($AA3,$AC$3:$AD$11,2,0) or AB3=OFFSET($AD$12,-$AA3,) or AB3=CHOOSE(9-$AA3,$AD$11) Arvi Laanemets "SteveC" wrote in message ... I have the following list in AC3:AD11 Qtr Ago Date 8 6/30/2004 7 9/30/2004 6 12/31/2004 5 3/31/2005 4 6/30/2005 3 9/30/2005 2 12/31/2005 1 3/31/2006 In Column AA, rows 1000+, I have numbers randomly dispersed 1 through 8. In Column AC, I would like to return the proper date correpsonding to each number. How do I do this? I can't/don't want to use nested if statements. I supsect the best way is via a defined name? Thanks for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Dates to Number
Assuming that AC20 is looking up AA20: Use this formula, make sure Column AC is Date Formated: AC20: =LOOKUP(AA20,$AC$3:$AC$11,$AD$3:$AD$11) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551137 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Dates to Number
that's great, thanks.... interesting that you used "CHOOSE" haven't seen that
before either... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
Match two tables using unique ID number | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
I need to use a number in one worksheet to match text in another | Excel Worksheet Functions | |||
Find number of days between to dates | Excel Worksheet Functions |