Results 1 to 5 of 5

Get the data by looking up 2 values simultaneously similar to Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    81

    Get the data by looking up 2 values simultaneously similar to Vlookup

    Hi all,
    Greetings!!!

    Can anyone please help me out in getting a solution for the below problem.

    I have created 2 sheets in the attached workbook for my explanation. One is "Master sheet" and the other one is "To be filled".

    My requirement is that,
    I need to get the data extracted from "Master sheet" in the sheet "To be filled" for the columns that are empty ('Name' column & 'Material' column).

    The data has to be found out by looking at 2 values simultaneously (i.e. using 'Title' and 'Rev').

    Like using Vlookup, we give only 1 Lookup value and get the required data by specifying certain range.

    Can anyone please help me out in getting a formula (Not Macro) on "HOW TO GET THE VALUES / FILL THE CELLS BY LOOKING UP 2 VALUES SIMULTANEOUSLY" for the column 'Name' & 'Material' in the sheet "To be filled"?

    Many Thanks in advance for your time and to the solution that was provided.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for Values in Multiple Data Tables Simultaneously
    By slumeet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2016, 01:33 PM
  2. VLookup/Index,Match for Similar values
    By hpatel517 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2015, 06:35 AM
  3. Replies: 1
    Last Post: 04-30-2014, 05:49 PM
  4. [SOLVED] VLOOKUP Multiple values (or similar)
    By kiwiana23 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2012, 08:57 PM
  5. vlookup similar values
    By sanlen in forum Excel General
    Replies: 3
    Last Post: 12-14-2010, 12:25 PM
  6. Similar to Vlookup, matching a series of values as opposed to one
    By tuna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2010, 09:32 AM
  7. Vlookup on a worksheet with similar values
    By GWHITE1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2005, 12:20 PM

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