| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Q
How could I create a formula that would find Today()-1 in a range
BA1:BA7 and return the value in the corresponding cell in BB1:BB2? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Q
On Sun, 18 Jan 2009 06:04:18 -0800 (PST), Seanie
wrote: How could I create a formula that would find Today()-1 in a range BA1:BA7 and return the value in the corresponding cell in BB1:BB2? What is "the corresponding cell"? Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Q
I presume that you meant BB1:BB7
=INDEX(BB1:BB7,MATCH(TODAY(),BA1:BA7,0)) -- __________________________________ HTH Bob "Seanie" wrote in message ... How could I create a formula that would find Today()-1 in a range BA1:BA7 and return the value in the corresponding cell in BB1:BB2? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Q
On Sun, 18 Jan 2009 14:26:06 GMT, Lars-Åke Aspelin
wrote: On Sun, 18 Jan 2009 06:04:18 -0800 (PST), Seanie wrote: How could I create a formula that would find Today()-1 in a range BA1:BA7 and return the value in the corresponding cell in BB1:BB2? What is "the corresponding cell"? Lars-Åke If we should read BB1:BB2 as BB1:BB7 you may try VLOOKUP, like =VLOOKUP(TODAY()-1,BA1:BB7,2,0) Hope this helps / Lars-Åke |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Q
Thanks guys, yes it was a typo
=INDEX(BB1:BB7,MATCH(TODAY()-1,BA1:BA7,0)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Linear Mode
