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.
- please help with this:
Enter a nested INDEX and MATCH function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Employee_ID 31461 and select Salary in cell K6 to test the function. - 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.
