|
|
#1
01-26-2019, 11:21 AM
|
|||
|
|||
Vlookup fails to select latest date/amt
Col. D E F G
DATE Dec31 bal. On hand Last Qtr Value =Vlookup(Max($D$4:$D20),$D$4:$G20,2,T) formula in D4 row 4 12/31/2018 $26.50 $24.00 $25.50 01/31/2019 $26.50 $23.50 $24.00 02/28/2019 $26.50 $24.25 $23.50 MS Excel 2007 Spreadsheet, Windows 7 Last edited by rbul1; 01-26-2019 at 11:31 AM. Reason: to correct alignment of data 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 return the status description relating to the latest date in
|
garymon9AX | Excel | 2 | 08-21-2018 10:02 AM |
|
What is the Latest Version of MS Office in 2018?
|
adbast | Word | 3 | 05-15-2018 12:12 PM |
| How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
|
Lookup & Import Earliest/Latest Date for Activity?
|
ekeithjohnson | Excel | 1 | 08-25-2014 09:24 AM |
| the latest message in my inbox gets deleted | Jmkary | Outlook | 1 | 01-27-2011 12:36 PM |
Windows 7 32bit 
Office 2007
Threaded Mode