I am trying to match the value of column A on the first tab and return the scores for each condition in the correct columns. I tried VLOOKUP with the fuction below but could not figure out how to return the conditions in the correct column.
Here is the formula i tried.
=VLOOKUP(A3, Data!A2:C20,3,false)
>Solution :
use:
=INDEX(IFNA(VLOOKUP(A2:A&SUBSTITUTE(B1:D1, " Score", ),
{Data!A:A&Data!B:B, Data!C:C}, 2, )))
