elsuji
12-07-2019, 03:19 AM
Dear Team,
I am having two work books (Sample 1 and sample 2).
I need to copy data from Sample 1 (Column D & Column E) to Sample 2 (Column E & Column F) by matching Model (Column B) & M/c Sl.No (Column C).
For that i am writing VLOOKUP formula "=VLOOKUP(B4&C4,'[Sample 1.xlsx]Sheet1'!$B$2:$H$474,4,TRUE)"
But this formula is not working as per my condition. It is updating the wrong values on data's.
I am attaching the files here for your reference.
Any one help me to short out this issue.
Is there any other method for doing this also let me know
I am having two work books (Sample 1 and sample 2).
I need to copy data from Sample 1 (Column D & Column E) to Sample 2 (Column E & Column F) by matching Model (Column B) & M/c Sl.No (Column C).
For that i am writing VLOOKUP formula "=VLOOKUP(B4&C4,'[Sample 1.xlsx]Sheet1'!$B$2:$H$474,4,TRUE)"
But this formula is not working as per my condition. It is updating the wrong values on data's.
I am attaching the files here for your reference.
Any one help me to short out this issue.
Is there any other method for doing this also let me know