hello,

how can i crate a sheet that when you write a number of a rocerd "from a table in sheet 1" appers on a cell in sheet 2 ?

For example, i made a table in sheet 1 of deitals of a movie. this table has the numbers of movies and the location of it and when was it made.

i want to crate a sheet which is a place where they can look for movie details just by writing the Number of the movie. and the details appers for them