Try this Array Formula to see if this is what you are trying to achieve.
![]()
=INDEX(Values!$A$2:$F$12,MIN(IF(ISNUMBER(SEARCH(A1,Values!$A$2:$F$12)),ROW(Values!$A$2:$A$12)-ROW(Values!$A$2)+1)),MIN(IF(ISNUMBER(SEARCH(A1,Values!$A$2:$F$12)),COLUMN(Values!$A$2:$F$2)))-1)
Bookmarks