Results 1 to 3 of 3

Thread: Lookup Based on Criteria

  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    7
    Rep Power
    0

    Question Lookup Based on Criteria

    Hi,
    I am looking For VBA to lookup on user specified columns.(i.e User should able to select a column to lookup on another sheet and again user has to select on which column value has to be looked up). I am attaching the sample book. Please have a look and help me out in this issue

    Regards
    Maruthi
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi

    Why you need VBA ?

    Try either VLOOKUP or INDEX/MATCH functions

    Please find attached.

    HTH
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Jun 2011
    Posts
    7
    Rep Power
    0
    Hi,
    Thanks for earlier reply. I used to do Vlookup earlier.I have lot of files to do per do. I cannot do manually. So i am looking for a VBA code to automate by giving column names by input box.Can you please provide the code
    Regards,
    Maruthi

Similar Threads

  1. Sum Based on Lookup
    By wsadaqa in forum Excel Help
    Replies: 3
    Last Post: 05-20-2013, 09:17 AM
  2. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  3. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 PM
  4. Lookup on Multiple Criteria
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 09-15-2011, 10:36 PM
  5. Find Value Based On Criteria
    By excel_learner in forum Excel Help
    Replies: 10
    Last Post: 07-30-2011, 10:27 AM

Posting Permissions

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