Excel Make list and fetch values

Question

I have a little doubt when making an excel file.

In my excel I have a page (Leaf 1) with tables and various values. I wonder if it is possible to make a list in "Folha2" and when choosing an option it gives me a value that is in the table of "Folha1" to be able to make a calculation on sheet two.

Sheet 1:

1 - 100 - 200
2 - 200 - 300  

Sheet 2:

// aqui tenho uma lista com o Valor 1 e 2 e quero que ao selecionar o 2 mostre o valor 200 e 300
2 - 200 - 300

Answer 1

A suggestion would be to create a list of then a function PROCV to fetch values from other columns, example:

Create a spreadsheet called list which will contain the data to be searched, according to the image below:

Create another worksheet called fetch, select the set of cells where you want to create the list, go to the tab then in in allow selects the option list, and in source select the range of cells from the list, as shown below:

The list of values of the first column of the list sheet will be created.

In cell B1 of the worksheet search do a function PROCV, to search in the list the selected value and return the column with index 2:

=PROCV(A1;lista!$A$1:$C$2;2)

This function will search in the spreadsheet list the value selected in cell A1 and return the column with index 2, that is selected 1 will return 100, selected 2 will return 200.

Repeat the procedure for cell C1 to return to column with index 3

=PROCV(A1;lista!$A$1:$C$2;3)

Upshot