Hi,
This topic was discussed on another thread but the problem hasn't been resolved.
I copy information from one report to the other. The first report (A), I use as my case work tracker and have a lot of information on. But only copy few details of each case to the other workbook (B) i.e. a shared workbook used by the rest of the team on a share drive. Basically when I copy the case data to from, A to B a lot of details get copied on to B (including the client name column). I am able to auto-populate in A is the serial number corresponding to that client's name in B. And this is done by the following formula.
=INDEX('[CPH RELO Reporting 2014.xlsx]IMMIG -Fragomen '!$A$3:$A$202;MATCH(D75;'[CPH RELO Reporting 2014.xlsx]IMMIG -Fragomen '!$F$3:$F$202;0))
However, if the name repeats in the column F, the formula gave the first instance where the name appears as the result. Which is not the correct serial number, I need it to find the serial number for the last/latest entry of the respective names from the bottom as against the first from the top which the formula is providing now.
Any suggestions?
This topic was discussed on another thread but the problem hasn't been resolved.
I copy information from one report to the other. The first report (A), I use as my case work tracker and have a lot of information on. But only copy few details of each case to the other workbook (B) i.e. a shared workbook used by the rest of the team on a share drive. Basically when I copy the case data to from, A to B a lot of details get copied on to B (including the client name column). I am able to auto-populate in A is the serial number corresponding to that client's name in B. And this is done by the following formula.
=INDEX('[CPH RELO Reporting 2014.xlsx]IMMIG -Fragomen '!$A$3:$A$202;MATCH(D75;'[CPH RELO Reporting 2014.xlsx]IMMIG -Fragomen '!$F$3:$F$202;0))
However, if the name repeats in the column F, the formula gave the first instance where the name appears as the result. Which is not the correct serial number, I need it to find the serial number for the last/latest entry of the respective names from the bottom as against the first from the top which the formula is providing now.
Any suggestions?