Hello everyone,
So I thought I would try to share this problem with you, this forum has been very helpful to me.
So I have a worksheet of data with names and salaries for each month (I have reduced the number of months for this purpose). I am building a separate worksheet to analyse those names against there monthly salaries. I have included a copy of the spreadsheet in this OneDrive link ([url]https://1drv.ms/x/s!AgQdYsSdg735crYwBr016fE5WlU)[/URL]
So on the first column I am using an index formula to extract all unique names from the stacked up column as employees might join and leave from month to month. Next, I am using the VLookup to match names and month and extract corresponding salaries.
This works fine until the VLookup finds a name that is not matching in that particular month (someone left or joined) and just populates the cell with the next name's value. (Highlighted)
I would be very grateful if someone could please help with this.
Many thanks.
So I thought I would try to share this problem with you, this forum has been very helpful to me.
So I have a worksheet of data with names and salaries for each month (I have reduced the number of months for this purpose). I am building a separate worksheet to analyse those names against there monthly salaries. I have included a copy of the spreadsheet in this OneDrive link ([url]https://1drv.ms/x/s!AgQdYsSdg735crYwBr016fE5WlU)[/URL]
So on the first column I am using an index formula to extract all unique names from the stacked up column as employees might join and leave from month to month. Next, I am using the VLookup to match names and month and extract corresponding salaries.
This works fine until the VLookup finds a name that is not matching in that particular month (someone left or joined) and just populates the cell with the next name's value. (Highlighted)
I would be very grateful if someone could please help with this.
Many thanks.