Hello Experts,
I created an attached sample that I will reference. We create concatenate statements and vlookups to find values from one tab to another tab. The sample created is in the same tab but the result is the same. The problem arises when the original hard copy entries (columns A thru C) create the same concatenate statement (column D) because the values in A thru C are the same. The vlookup (in column L) only finds the first value (in columns M, N and O). The sample shows the same concatenate statement in rows 3 and 5 that are causing the problem.
My question ... can there be a formula that alerts the individual that the manual entries made create the same concatenate statements on column D? Sometimes we have hundreds of rows and visually we cannot always catch the duplicates. Something that appears somewhere on the spreadsheet to show the issue and where the problem may be. Even if an error message appears in the final vlookup results, in this sample M,N and O row 5 showing the results are not correct. I hope I explained that well enough for you to understand. Thank you.
I created an attached sample that I will reference. We create concatenate statements and vlookups to find values from one tab to another tab. The sample created is in the same tab but the result is the same. The problem arises when the original hard copy entries (columns A thru C) create the same concatenate statement (column D) because the values in A thru C are the same. The vlookup (in column L) only finds the first value (in columns M, N and O). The sample shows the same concatenate statement in rows 3 and 5 that are causing the problem.
My question ... can there be a formula that alerts the individual that the manual entries made create the same concatenate statements on column D? Sometimes we have hundreds of rows and visually we cannot always catch the duplicates. Something that appears somewhere on the spreadsheet to show the issue and where the problem may be. Even if an error message appears in the final vlookup results, in this sample M,N and O row 5 showing the results are not correct. I hope I explained that well enough for you to understand. Thank you.