Home > Mobile >  Return values from another tab if one value matches and another meets criteria
Return values from another tab if one value matches and another meets criteria

Time:10-05

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)

enter image description here

  • Related