Drop Downs & Lookups?
Hello There,
For my A Level coursework I have to make a Cinema Spreadsheet. I have used drop downs from the forms toolbar. However I also need to keep a record of what films have been viewed etc. Normally if it was just writen into the cell it would be a simple =ScreenA!A2 formula.
However it is a drop down giving a number in the cell link show below...
http://i300.photobucket.com/albums/n...rmula_Help.png
What I was wondering is there a formula i could use such as a lookup or If formula so it can say for example IF Cell X = 1 than it would be Michael Jackson This Is It or something similar? I hope that makes sense... I'm not the best with formulas...
Sure. If you could just let us in on where the lookup would look to find Michael Jackson.is there a formula i could use such as a lookup or If formula so it can say for example IF Cell X = 1 than it would be Michael Jackson
<have to sit on my hands now not to include something silly about the whereabouts of MJ>
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Lol...
TempScreen!B17
http://i300.photobucket.com/albums/n...TempScreen.png
Last edited by shg; 11-15-2009 at 05:43 PM. Reason: deleted spurious quote
See if this helps!
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks