Need Macro to Concatenate and Vlookup the result.

[parasarora]

Hey Everyone,

I just came across this amazing forum.
Spent alot of time reading it.

Therefore thought why not i should try my luck here too.

I have attached a file.
It has 2 Tabs "Historical" and "Data"

What i want to do, in one single Macro

Historical Tab
Concatenate Columns (B2,E2,G2,L2,N2) and show result in last empty Column which is U2.
same for the next row. Columns (B3,E3,G3,L3,N3) and show result in last empty Column which is U3.
And goes on for the whole historical file.

Data tab.
Concatenate Columns (B2,E2,G2,L2,N2) and show result in last empty Column which is U2.
same for the next row. Columns (B3,E3,G3,L3,N3) and show result in last empty Column which is U3.
And goes on for the whole Data file.

Data tab.
In Column V2, Now i want to compare the result of Historical tab U2 and Data tab U2.
to show if they match or not.
If they match, it is a duplicate. if not then it is ok.

If there is another post that has a solution to this, please mark it down for me to look at it.
otherwise, please help provide the solution for this.
thanks.

let me know if any questions.

PIR - Copy.xls

[Krishnakumar]

U2 on Data tab,

=IF(ISNUMBER(MATCH(B2&E2&G2&L2&N2,INDEX(Historical!B:B&Historical!E:E&Historical!G:G&Historical!L:L&Historical!N:N,0,0),0)),"Duplicate","OK")

copy down the formula

[xlbiznes]

Here you go, your sample workbook with the code added.

[parasarora]

Thanks both the members. this is amazing
Both the formula and the macro works.

thank you so much! I am loving this forum!!!!

[xlbiznes]

You are welcome.