Results 1 to 4 of 4

Excel 2007 : Help with a complicated lookup/reference array formula...

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Help with a complicated lookup/reference array formula...

    I don't really know how to appropriately title this thread.

    I'm having a problem with this formula...I got it from another thread in here and changed it to suit my needs. It has been working fine exept for one flaw I can't seem to figure out...The problem is, if a value in A2 does not match any values in the table area (B5:G10), a false result is returned. In this example sheet that result is the first row title. I would like it to read blank if a value cannot be found if possible...thoughts?

    I built a sample sheet with the below formula.

    {=IFERROR(INDEX($B$5:$B$10,MIN(IF($B$5:$G$10=A2,ROW($B$5:$B$10)-MIN(ROW($B$5:$B$10))+1,"")))&INDEX($B$4:$G$4,MIN(IF($B$5:$G$10=A2,COLUMN($B$4:$G$4)-MIN(COLUMN($B$4:$G$4))+1,""))),"")}
    Attached Files Attached Files
    Last edited by Speshul; 07-13-2012 at 02:34 PM.

Thread Information

Users Browsing this Thread

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

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