Hey guys,
I'm having an issue that I can't seem to resolve. I have a sheet my masterlist that gets information from many other sheets in the file. However, the masterlist has to be able to be sorted and therefore my excel formulas have to be flexible.
I have in my masterlist firm names in column A and different funds (funds offered by investment firms ex canadian equity, US small cap etc) for each firm in column A of the same sheet. Then my excel file has a sheet for each firm name (with the name matching the firm). In each sheet I can have many different funds (with repeats) how can i return the most recent date?
I was using :
=MAX(INDIRECT("'"&B11&"'!A3:A1048576")), but that was before I started adding multiple different funds on each sheet. What I have been trying now is:
=VLOOKUP(B13,INDIRECT("'"&A13&"'!$A$3:Az1048576"),6,FALSE), this will lookup the fund name in B13 in the sheet with the firm name that is in cell A13 and return the date from row 6. I can't seem to return the max value for this however, is there anyone that could help point me in the right direction?
Thank you,
David
Bookmarks