Results 1 to 8 of 8

Trying to use Vlookup with multiple colums

Threaded View

  1. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,923

    Re: Trying to use Vlookup with multiple colums

    Hello Sandramv and Welcome to Excel Forum.
    This is how an array entered formula* might be used to get the list of records meeting the conditions of "Column R is <=today's date [and not blank] and column T is = 0" (as shown on sheet 2).
    Formula: copy to clipboard
    =IFERROR(INDEX('Project Ready'!B$2:B$5241,SMALL(IF(('Project Ready'!$R$2:$R$5241<=$A$1)*('Project Ready'!$R$2:$R$5241<>"")*('Project Ready'!$T$2:$T$5241=""),ROW($2:$5241)-1),ROW(1:1))),"")

    Note: Date is placed in cell A1.
    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup to show value from 2 colums
    By SPIG in forum Excel General
    Replies: 4
    Last Post: 07-26-2017, 08:13 AM
  2. Vlookup and concatenate multiple colums of date
    By Ashtangi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 10:00 PM
  3. Returing values from multiple colums in VLOOKUP
    By narendrabr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 09:44 AM
  4. Formula required for comparing multiple colums to multiple colums
    By Pringgles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 07:23 AM
  5. vlookup w/ 3 colums
    By gentelmanjack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2010, 07:05 PM
  6. VLookup 2 Colums 2 spreadsheets
    By beaker in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2008, 10:55 AM
  7. [SOLVED] match to colums vlookup
    By JavyD in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 10:05 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