+ Reply to Thread
Results 1 to 2 of 2

Double Vlookup if/then

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Double Vlookup if/then

    Hi,

    i have a complicated vlookup/index/match .. whatever formula will work,

    On my sheet "Main", column A, i have a list of phone numbers, so lets say 555-555-5555, this number is also in worksheet "ListeALL" in column N.

    i need a value return on both condition...

    In sheet "ListeAll", if column b = FÉVRIER and column N = (phone number in MAIN column A), then return me the Value in column F

    MAIN

    A B
    8191245784 (FORMULA TO RETURN VALUE AN if A is met in LISTEALL N and FÉVRIER in B)

    LISTEALL

    A B C D E F G h I J K L M N
    Kia Sherbrooke FÉVRIER 604111 12-02-15 20:33 27-02-15 00:00 AN 2006 kiashfev0009 13201 -4.00 N 1 8191245784
    Kia Sherbrooke FÉVRIER 604114 12-02-15 20:33 26-02-15 00:00 AN 2088 kiashfev0012 13201 -4.00 N 1 8191546781

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Double Vlookup if/then

    In B1 of Main

    =INDEX(ListAll!$F$2:$F$3, SUMPRODUCT(--(ListAll!$N$2:$N$3=A1), --(ListAll!$B$2:$B$3="FÉVRIER"), ROW(ListAll!$A$2:$A$3)-1))

    See attachment
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. [SOLVED] Double VLOOKUP ?
    By KiBBo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2013, 02:14 PM
  2. [SOLVED] Double VLOOKUP?
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-02-2013, 08:35 AM
  3. Double vlookup
    By jame24 in forum Excel General
    Replies: 1
    Last Post: 01-18-2012, 12:43 PM
  4. Double Vlookup
    By topgunnerp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2007, 07:22 AM
  5. IF and double VLOOKUP
    By SamuelT in forum Excel General
    Replies: 4
    Last Post: 05-26-2006, 11:13 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