Posted to microsoft.public.excel.programming
|
|
Display value in same row of most recent date in a different colum
"galimi" wrote
=VLOOKUP(MIN(A1:A7),A1:D7,2,FALSE)&VLOOKUP(MIN(A1: A7),A1:D7,4,FALSE)
Based on the OP's spec:
... corresponding to the row with the most recent date.
should the MIN be MAX instead ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|