1

I am trying to turn a the table on the left side to the one on the right.

vlookup based on multiple criteria

How can it be achieved? I have tried This, but it did not work.

ZygD
  • 2,459
  • 12
  • 26
  • 43
gbox
  • 113
  • 5

1 Answers1

1

In I2 you should write this array formula (enter it using Ctrl+Shift+Enter):

=INDEX($C$2:$C$9,MATCH(1,($G2=$A$2:$A$9)*(H2=$B$2:$B$9),0))

Then you can copy it to other columns (K, M, O).

array formula, index, match, multiple criteria

ZygD
  • 2,459
  • 12
  • 26
  • 43
  • Using the formula I get N/A but the result is correct as seen here: https://imgur.com/a/6Ttan4K – gbox Mar 26 '19 at 14:06
  • 1
    Do you see curly braces in my screenshot? `{ }` ? That is what you get when you actually use Ctrl+Shift+Enter and not simply Enter ;) – ZygD Mar 26 '19 at 14:15