Results 1 to 3 of 3

Thread: Lookup Based on Criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-15-2012, 06:08 AM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    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)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Based on Lookup
    By wsadaqa in forum Excel Help
    Replies: 3
    Last Post: 05-20-2013, 09:17 AM
  2. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
    By d380013 in forum Excel Help
    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

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
  •  

Forum Rules