Forum Discussion
Solved
Lookup / Index / Match - look up values corresponding to MAX date
Hello, Me again - I am really struggling with this report 😞 For each Account name in column B (indirect tab), I need columns A, C, D, E, F and G to lookup the corresponding info where its t...
Hi, Simply you can sort the column Definitive Ending Date Newest to Oldest and do a vlookup on account name to fetch all details.
Hi, Simply you can sort the column Definitive Ending Date Newest to Oldest and do a vlookup on account name to fetch all details.
Thanks! I guess the only thing I can't do is pick out the unique account names - I have to get those from a pivot.