___ ___ erkimt Excel Do list and get values ______ qstntxt ___

I have a little doubt when making a file in Excel.

In my excel have a page (Sheet1) with several tables and figures. I wonder if it is possible I make a list in the "Sheet2" and choose an option it give me a value that is in the Table "Sheet1" to be able to make a calculation sheet in two.

Sheet 1:

%pre%

Sheet 2:

%pre%     

______ ___ azszpr25155

One suggestion would be to create a list of a function after VLOOKUP to seek the values of the other columns, eg:

Create a call sheet list that contains the data to be fetched, as the image below:

Createanotherworksheetnamedsearch,selecttherangeofcellswhereyouwanttocreatethelist,goonthe then allow select the list and < strong> source select the list cell range as below:

willbecreatedtolistthevaluesofthefirstcolumnoftheworksheetlist.

InthespreadsheetcellB1makeasearchfunctionVLOOKUP , to search the list the selected value and return the column with index 2:

%pre%

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

Repeat for cell C1 to return the column with index 3

%pre%

search Filmography

    

___