View Single Post
 
Old 05-09-2016, 09:43 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

In G2 copied down...
Code:
=INDEX(Sheet1!$G$3:$J$7,
          MATCH($B2&$E2,Sheet1!$C$3:$C$7&Sheet1!$A$3:$A$7,0),
          MATCH($A2,Sheet1!G$1:J$1,0))
IMPORTANT
  • This is an array formula
  • Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
  • If entered correctly, the formula will be enclosed in {brackets}
  • Do not enter the {brackets} manually
Reply With Quote