Hi all
I am attempting to do an index match formula which is using a date element. The issue I am having is that the date in one sheet is stated as Jun-2024 format type General (below) and on another sheet I have Jun-24 but this is listed as 28/06/2024 but has been formatted as mmm-yy showing as Jun-24. Although they may be a match cosmetically I am assuming the lookup is not working due to them not being the same date as such. Is there a way I can make the dates match within the lookup to get the desired result ?
(no issues within constructing the index match formula itself just within the second match aspect of getting dates to match)
I am attempting to do an index match formula which is using a date element. The issue I am having is that the date in one sheet is stated as Jun-2024 format type General (below) and on another sheet I have Jun-24 but this is listed as 28/06/2024 but has been formatted as mmm-yy showing as Jun-24. Although they may be a match cosmetically I am assuming the lookup is not working due to them not being the same date as such. Is there a way I can make the dates match within the lookup to get the desired result ?
(no issues within constructing the index match formula itself just within the second match aspect of getting dates to match)