Thread: Index to return value based on 2 conditions
View Single Post
 
Old 01-28-2017, 05:11 AM
george batshon george batshon is offline Windows 10 Office 2013
Novice
  
Join Date: Jan 2017
Posts: 2
george batshon is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Hi
in I2 enter =INDEX($B$2:$D$4,MATCH($G2,$A$2:$A$4,0),MATCH($H2, $B$1:$D$1,0)) and drag down
Much appreciated!! it worked!
Reply With Quote