creating summary

[Jeycel]

i don't know what to do with this... i have a excel workbook that contains two worksheet in sheet 1 contains film no., name, age, gender, date and company name....and in sheet 2 contains the summary ....but what i want is i only type the film no. and then the other information will come out in the specified rows and column....pls. help me....

 

[FDibbins]

Take a look at using the =vlookup() function. The syntax is...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match