Luiz Boas

Luiz Boas

  • NA
  • 26
  • 501

Giving the cell value, find the row, column.

Nov 18 2020 2:45 PM

I have a spreadsheet with 10 columns, I want for example to inform the cell value and the column and get back the value contained in the cell that is in the same row found but in a different column.

In the picture for example I want to give the cell value "b" and the column A then search the line where "b" was found and get back the value from the same line but in a different column, in the example Column H, value "PPP". 

 

Answers (2)