PPRuNe Forums - View Single Post - Lookup function - Excel
Thread: Lookup function - Excel
View Single Post
Old 16th August 2005 | 15:01
  #9 (permalink)  
ExGrunt
 
Joined: Mar 2003
Posts: 285
Likes: 0
From: England
A slightly shorter solution is:

=IF(COUNTBLANK(B3:J3)<>9,INDEX($B$2:$J$2,1,MAX(ISTEXT(B3:J3) *{1,2,3,4,5,6,7,8,9})),"")

As above, this is an array formula so copy it to cell K3, then press Ctrl-Shift-Enter.

EG
ExGrunt is offline