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
___