+ Reply to Thread
Results 1 to 7 of 7

Match the data with the help of Vlookup

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Match the data with the help of Vlookup

    Hello Friends..........

    i am looking for a vba code through which i want to search some data but no solution i got..........

    here attached a Sample excel file.........it contains 2 sheets i.e. Sheet1 and Deletion

    i want vlookup in Col-H of Sheet1...........then Vlookup match Deletion sheet's E_Code (Col-B) in Sheet1's E_Code (Col-B)

    if found show E_Code in Col-H else display #n/a

    please see sample file for ready reference............
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Match the data with the help of Vlookup

    In H2 =VLOOKUP(B2,Deletion!$B$2:$B$20,1,0) then copy down.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Match the data with the help of Vlookup

    Thanks for reply.........sir i want to do this with the help of VBA macro

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Match the data with the help of Vlookup

    ok. here is a link on how to do that.

    http://www.cpearson.com/excel/Callin...ionsInVBA.aspx

    Not sure why you need VBA to do something as simple as you ask.

  5. #5
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Match the data with the help of Vlookup

    Thanks for reply........sir i attached a sample data of 100 employees.........but actual data is more than 9000 employees........i open above said link.......in the line"Res = Application.WorksheetFunction.VLookup(123,Range("A1:C100"),3,FALSE)"........i think it is not working on more than 9000 employees (every month the number of employee can be different, in next month it may be 9500 or 8000)how to do that?

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Match the data with the help of Vlookup

    Please Login or Register  to view this content.
    You need to change Chip's range to what it is in your file as shown above. His is only an example of how to do it. Still not sure I understand the need for a Macro to do what is built into Excel. I believe in the KISS principle.
    Last edited by alansidman; 10-05-2018 at 12:53 AM.

  7. #7
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Match the data with the help of Vlookup

    Thankyou sir it is working........but i want some changes in this code........

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data validation and automatically Vlookup with match data
    By Anisusa in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 06-06-2018, 04:11 PM
  2. How do I match and combine data using VLookup?
    By sunshine123 in forum Excel General
    Replies: 11
    Last Post: 05-04-2015, 11:19 PM
  3. [SOLVED] how do I vlookup a cell with mulitple data to match another another multiple data,
    By kemi2299 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2013, 08:21 AM
  4. Best way to Match Data i.e Vlookup
    By johnny_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2013, 12:18 PM
  5. using a vlookup to match data >0 between two worksheets
    By Kinetic_Solutions in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2013, 03:27 PM
  6. How to use VLOOKUP to match the data?
    By kalucharan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2012, 02:26 AM
  7. Trying to use a VLOOKUP to match data...
    By JonnyNYC90 in forum Excel General
    Replies: 3
    Last Post: 06-27-2011, 11:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1