VLOOKUP function does not work in Excel

Asked

Viewed 404 times

0

I’m making formulas in Spreadsheets Google, but when making a conditional formatting is stating that the formula is incorrect.

=VLOOKUP(C3; Concursos!C3:H5; 1; FALSE)

All cells contain whole numbers.

excel google spreadsheets fórmula

  • You are trying to search a certain value in excel spreadsheet?

  • Try using point and comma " ; "instead of commas " , ".

1 answer

0

Use the function PROCV to search a value in a table.

The syntax is:

PROCV(valor_procurado; matriz_tabela; núm_índice_coluna; [intervalo_pesquisa])

Explaining better:

=PROCV(Value you want to search; range in which you want to search the value; the column number in the range containing the value of return; Exact Match or Approximate Match - indicated as 0/FALSE or 1/TRUE).

For example:

=PROCV(B3;A2:C7;2;FALSO)

Read more on: PROCV function

  • @Eliseub.I don’t understand.

Browser other questions tagged excel google spreadsheets fórmula

You are not signed in. Login or sign up in order to post.