Hello all!
Would like to seek advice if it is possible to vlookup based on a critera like for example
AA - 1 - 01/01/2013 - $2
AA - 1 - 10/01/2013 - $4
AA - 2 - 01/01/2013 - $5
AA - 2 - 10/01/2013 - $8
1st Criteria = AA
2nd Criteria = 1
where the vlookup will return the latest date (amount a range of dates) amount of $4.
Appreciate your advice!
Thanks!
Bookmarks