Search formula

[RedPanther]

Hello,
I have a little question and i know it is easy for you guys but i'm ne
to excel.
I wont to make a list of videos that I have. But then, the difficul
part, i wont to make a search field where I type the name of the film
Then in an other box comes a number, a number I gave to the movie. Ho
do I do that

 

[Frank Kabel]

Hi
have a look at VLOOKUP for this See:
http://www.contextures.com/xlFunctions02.html