If A1="Bob", B1="Sue", C1="Jerry" and A2=2, B2=1, C2=3 (regardless of how those numbers got there - static or formula), then try:
=INDEX(A1:C1,0,MATCH(MIN(A2:C2),A2:C2,0))
If A1="Bob", B1="Sue", C1="Jerry" and A2=2, B2=1, C2=3 (regardless of how those numbers got there - static or formula), then try:
=INDEX(A1:C1,0,MATCH(MIN(A2:C2),A2:C2,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks