I have a vlookup code that will update the text "UG" in a destination column if the result matches with the source sheet.
Example :The code compares "Sheet B" with "Sheet A" and if a match is found in "Sheet A" , it updates the text "UG" in a column in sheet A.
I want to make a small modification here.
Instead of updating the text "UG" in sheet A, I want to update the value that is there in the "Sheet B" in col B .
Please Login or Register to view this content.
Why not just use a regular vlookup?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I just started learning VBA and fond this code in google in a forum and I modified it as per my need. So I'm not sure how to do it in vlookup using VBA. Can you pl assist?
sorry, my VBA is really weak
Oh okay
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks