Results 1 to 12 of 12

Vlookup index function error

Threaded View

macro12 Vlookup index function error 03-24-2022, 10:54 AM
Glenn Kennedy Re: Vlookup index function... 03-24-2022, 11:04 AM
macro12 Thank you! This is a much... 03-24-2022, 02:10 PM
WideBoyDixon Re: Vlookup index function... 03-24-2022, 11:05 AM
Glenn Kennedy Re: Vlookup index function... 03-24-2022, 02:29 PM
macro12 Thanks! Is there a way to... 03-24-2022, 04:17 PM
macro12 See attached. 03-24-2022, 04:18 PM
Glenn Kennedy Re: Vlookup index function... 03-25-2022, 04:15 AM
Glenn Kennedy Re: Vlookup index function... 03-25-2022, 04:16 AM
macro12 Thank you! You a genius! I... 03-25-2022, 08:22 PM
Glenn Kennedy Re: Vlookup index function... 03-26-2022, 03:41 AM
AliGW Re: Vlookup index function... 03-26-2022, 03:43 AM
  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82

    Vlookup index function error

    Hi! I am having trouble with the formula in Column B:

    =IFERROR(INDEX('By Task Order'!$B$1:$B$200,AGGREGATE(15,6,ROW('By Task Order'!$C$1:$C$200)/(VLOOKUP(INDEX($A$1:A3,MATCH(1,(-(ISNUMBER($A$1:A3))))),'By Task Order'!A:C,3,0)='By Task Order'!$C$1:$C$200),ROW()-(((MATCH(2,(1/($B$1:B3=""))))))-1)),"")

    It won't pull all the rows for the specific employee and I can't figure out the reason, e.g. row 289. It happens quite frequently. Please help!
    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. Replies: 6
    Last Post: 10-29-2021, 05:52 PM
  2. [SOLVED] Vlookup, Index Match both returning #N/A value not available error
    By SkillzWhoKillz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2021, 06:28 AM
  3. [SOLVED] Error in Vlookup Index formula
    By rizmomin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2017, 01:57 AM
  4. [SOLVED] Need Help with Vlookup and Index Functions to Solve for Error
    By trandle in forum Excel General
    Replies: 13
    Last Post: 05-22-2015, 05:25 PM
  5. [SOLVED] Vlookup Index error
    By cp41 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2014, 06:24 PM
  6. 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
  7. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 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