LinkBack URL
About LinkBacks
Hi everyone,
Im searching the net for about 2hrs and i cant find the macro code for what im looking for. I have attached the excel file on how to code. Hope you can help me with my problem.
Thank you.
Book1.xlsx
Hi everyone,
Im searching the net for about 2hrs and i cant find the macro code for what im looking for. I have attached the excel file on how to code. Hope you can help me with my problem.
Thank you.
Book1.xlsx
Hi Kooper,
You can integrate below code for 1st vlookup in your main code:-
and for second vlookup :-
Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Hi dilipandey,
Im sorry i forgot to mention the Vlookup with Looping.
Thanks.
Okay.. no worries, you can use below code:-
Regards,Please Login or Register to view this content.
DILIPandey
<click on below 'star' if this helps>
Hi dilipandy,
How about this?
Please Login or Register to view this content.
Hi Kooper,
Code will automatically take care of looping and hence not required
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi dilipandy,
I have here an example code of vlookup loop. however, i cant manage to work this on the 2nd lookup. Hope you can help me on this.
I also attached my excel file. The cell highlighted in yellow is my problem.
with this code below, i want the 2nd lookup be integrated in the code im using while using the 2nd data named "Data2"
Book1.xlsmPlease Login or Register to view this content.
btw, sorry for the english.
Thank you.
Bump. .
Hi Kooper,
I have checked your code and you are not using vlookup (or any other kind of functionality) in your code.
Why don't you use the code I provided you in post#4 ?
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi DILIPandey,
Yes its not like vlookup but its the function is the same as vlookup. Anyway, is there a way to revised this code?
Thanks,
Kooper
Okay.. what if one day the order of Agent No. and Material codes interchanges i.e., lets say agent number changes :-
instead of
A
B
C
D
it become
A
C
B
D
Regarding any way to revise, I am afraid I would be able to do it as I like to simplify and make the things dynamic for future usage
Regarding,
DILIPandey
<click on below 'star' if this helps>
Hi DILIPandey,
Thank you.
Cheers
Suggest you to mark this thread as [SOLVED]
Regards,
DILIPandey
<click on below 'star' if this helps>
@Kooper
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks