PPRuNe Forums - View Single Post - Exel lookup help
View Single Post
Old 14th September 2013 | 06:40
  #5 (permalink)  
Lear_doctor
 
Joined: Oct 2002
Posts: 92
Likes: 0
From: Dubai, UAE
Resolved

Thanks to BOAC who came up with this brilliant solution

{=INDEX($F$3:$F$8,MATCH(B4&C4,$G$3:$G$8&$H$3:$H$8,0))}

best regards


The Doc

Last edited by Lear_doctor; 14th September 2013 at 06:41.
Lear_doctor is offline  
Reply