Creating Lookup Sheet

Hi, I'm new to this and hoping someone can help me. I have a list of my movies in excel. In cell A1 I have the location of where the movie is. Example location 1. Then in cell B, I have the names of the movies. I want to create on the same sheet a lookup cell where I can type in the name of the movie and on the next cell I get the location. Would greatly appreciate any help. I have cell 1 thru 3005. Thank again for any help.

ok it's not working perhaps I did not explain correctly. I want to type in for example D2 the name of the movie, then in another cell I want to see the results which would be the name of the movie + location.

Sorry I figured it out, know my question is, i have some repeated movies. I have them in several locations, how can I change the formula to find ALL locations. Again I want to thank you for youor kind help. Greatly appreciated.

Please Anyone. Iwant to have this list done by tonight, any help greatly appreciated.

Hi.

Have you tried auto filter - this would give you a tab across each column.

Example:
Click on the tab with the title of the film, within that column -a dropdown listing of all films will be shown, scroll down to the title you select, click on that, it would display all titles of that name - and on the basis that you have given a location code - it would display all data/info.