+ Reply to Thread
Results 1 to 3 of 3

Lookup Work Only in Box 1, Not Fully Work

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Lookup Work Only in Box 1, Not Fully Work

    hi all..

    i have a problem a data lookup, i have 4 box contains name that i want lookup
    i have use array funct: =IFERROR(INDEX($L:$L;SMALL(IF($K$3:$K$568=$F$2;ROW($K$3:$K$13));ROWS(G$4:G4)));"")
    but only Box 1 as work, for the other box can not show text (not working)..

    please, check this my related file

    any help, will be appreciated...

    john m
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: Lookup Work Only in Box 1, Not Fully Work

    Hope this works
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Lookup Work Only in Box 1, Not Fully Work

    thank you Azumi.....(matur suwun).
    nice to see you.

+ 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. Formula doesn't work fully - help to fix
    By Cazbag in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2016, 07:10 AM
  2. populate a list on one work sheet from multiple work sheets that meet a criteria
    By Kelly Linton-Selkirk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2015, 03:56 PM
  3. [SOLVED] Macro doesn't fully work. Need help with rows
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 06:07 PM
  4. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  5. Replies: 4
    Last Post: 11-04-2011, 12:37 PM
  6. Conditional format in macro, does not fully work
    By SET_student in forum Excel General
    Replies: 4
    Last Post: 02-10-2011, 06:53 AM
  7. Replies: 2
    Last Post: 07-11-2006, 11:15 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