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,""))),"")}
Bookmarks