+ Reply to Thread
Results 1 to 2 of 2

2 lookup_Value for Vlookup

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    1

    2 lookup_Value for Vlookup

    Alright guys I have been using Vlookup for a minute and I have a question

    I need to knowhow to make V lookup look for 2 Lookup_Value example below

    if A & B on sheet 1 are the same as A & B on sheet 2 copy C from Sheet 2

    TIA

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 2 lookup_Value for Vlookup

    Use INDEX/MATCH instead

    =INDEX(Sheet2!C:C,MATCH(1,INDEX((Sheet2!A:A=A1)*(Sheet2!B:B=B1),0),0))

    Avoid using full column references though and adjust based on your range
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. Replies: 1
    Last Post: 05-14-2014, 10:11 AM
  2. lookup_value in VLOOKUP formula
    By 99f150 in forum Excel General
    Replies: 7
    Last Post: 03-16-2010, 11:21 AM
  3. VLOOKUP where lookup_value is more than 1 colum
    By renatonetmail in forum Excel General
    Replies: 3
    Last Post: 08-27-2009, 02:22 AM
  4. Use Sheetname as Vlookup lookup_value
    By robjeeves in forum Excel General
    Replies: 1
    Last Post: 04-28-2005, 08:43 AM
  5. Update Vlookup lookup_value
    By Phil Floyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2005, 12:06 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