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
|