Dear friends
I need a help in solving below problem
I have some 6000 alphanumeric data in column B of sheet 1, I have same or some of the same alpha numeric data of sheet 1 in column B in sheet 2 also. In column C & column D of sheet 2 i have three digit numbers
Now i want to compare column B of sheet 1 with column B of sheet 2, find the matching no & copy the adjacent cell value of column C & D in sheet 2 to matching row of column in B of sheet 1 & place the values in column E column F
If this can be done thru either V or H look up or built in function it is good or else VBA code also OK
It is very urgent can any body help me
I need a help in solving below problem
I have some 6000 alphanumeric data in column B of sheet 1, I have same or some of the same alpha numeric data of sheet 1 in column B in sheet 2 also. In column C & column D of sheet 2 i have three digit numbers
Now i want to compare column B of sheet 1 with column B of sheet 2, find the matching no & copy the adjacent cell value of column C & D in sheet 2 to matching row of column in B of sheet 1 & place the values in column E column F
If this can be done thru either V or H look up or built in function it is good or else VBA code also OK
It is very urgent can any body help me