Results 1 to 16 of 16

Is this a VLOOKUP function?

Threaded View

  1. #10
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Is this a VLOOKUP function?

    One observation, the value, 103 in cell N14 is formatted as text, which cannot be directly compared to the value, 103 in cell N2, which is formatted as a number. You need the format to be consistent for this to work.

    Once you have corrected the format of N14, enter this formula into P2, and confirm it as an array formula.

    =IFERROR(INDEX($AQ$2:$AQ$15,MATCH(2,1/(($K$2:$K$15=K2)*($L$2:$L$15=L2)*($M$2:$M$15=M2)*($N$2:$N$15=N2)*(ROW($K$2:$K$15)<>ROW(K2))))),"")

    ...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.

    edit:-

    That might struggle to cope with 12,000 rows, maybe a helper column is needed.
    Last edited by jason.b75; 04-11-2016 at 07:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to Multiply the result of an IF function combined with a VLOOKUP function
    By ucca in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-28-2018, 02:32 AM
  2. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  3. Need help nesting an index/match function within a Vlookup function.
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 06:16 PM
  4. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  5. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  6. HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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