Dear Gurus,
Please help me with this macro to vlookup and insert the results eg. (K) for Korry at the whereused column as shown in the attachment. I have more than 1000++ to manually do this. Please help.
Rgds,
Catherine
Dear Gurus,
Please help me with this macro to vlookup and insert the results eg. (K) for Korry at the whereused column as shown in the attachment. I have more than 1000++ to manually do this. Please help.
Rgds,
Catherine
Last edited by cathchin; 01-13-2013 at 08:41 PM.
Catherine,
Its not clear as how your making the match. Im guessing Columns A,B,C and D on the results sheet will have data in them. Then you want to separate the values in Column C by ; and lookup the values in the Data sheet. So lookup 200-08108-9020-119 on the data sheet, find the match and make 200-08108-9020-119 = 200-08108-9020-119(K) and add Korry Esterline to column E and repeat for the rest of the values in column C. Is that correct?
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Mike,
Yes you are right on " lookup 200-08108-9020-119 on the data sheet, find the match and make 200-08108-9020-119 = 200-08108-9020-119(K)". I do not need a macro for " add Korry Esterline to column E "
I only need for column C. Please help.
Thank you,
Catherine
So will the names already be in column E? If so we can just use them to add the (K) ,(O) and (P) instead of having to look them up.
Give this a try
Please Login or Register to view this content.
Hi Mike,
The macro works like magic! I only change the below and it works well
aArr = .Range("a2").CurrentRegion
Thanks a million!
Catherine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks