lfnetwork.com mark read register faq members calendar

 10-09-2008, 12:23 PM #1 Astor @Astor It's Thornhill!     Status: Super Moderator Join Date: Mar 2008 Posts: 3,657 Anyone good with excel? Hi guys. I've been building some record sheets for wargaming, and i've been using lots of nifty functions and calculations, but i've hit a wall. I've put together a drop-down list using Data Validation, which is working perfectly. What I want is for information to be displayed in the cell next to the drop down list when I select one of the options (In this case, I want the points value of the unit to be displayed when I select one of the options). I've been trying for a bit now, and it's not getting me anywhere. Does anyone have any ideas that'll rescue me? Thanks, Astor. you may:
 10-09-2008, 03:08 PM #2 tk102 @tk102 Well past expiration date     Join Date: Jan 2004 Posts: 5,768 Current Game: FTL One solution would be to use the VLOOKUP function. Lets say you have the text values a, b, c, d, e, f in Cells A1:A6 and this is the list that you're using for your Data Validation (let's say that is in E1). Now let's say you have values 1, 2, 3, 4, 5, 6 in Cells B1:B6 and these are the corresponding values for text in A1:A6. And you want the person who's selecting a text value in E1 to have the numeric value appear in F1. The following formula in F1 will do this: =VLOOKUP(E1,A1:B6,2,0) Attached Images you may:
 10-09-2008, 03:18 PM #3 Astor @Astor It's Thornhill!     Status: Super Moderator Join Date: Mar 2008 Posts: 3,657 I thought it might be a lookup function, but couldn't get it to work properly, until you just explained it! Thanks tk! you may:
 10-11-2008, 10:34 PM #4 Astrotoy7 @Astrotoy7 A Face from The Past     Join Date: Apr 2002 Posts: 10,283 interesting. good stuff tk. always good to pick up more tips in such things. Im very much hardware and media/gaming focussed, hence excel is one thing Im entirely clueless in! mtfbwya Asinus asinum fricat you may:
 LucasForums > Anyone good with excel?

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home -------------------- Network     Star Wars Gamer     Knights of the Old Republic     Mixnmojo.com     Monkey Island Discussion     Brutal Legend Discussion     Grim Fandango Discussion     Psychonauts Discussion at Razputin's Domain     Sam And Max.Net     The Dig Museum     Full Throttle Discussion     IndyJones.net     Fracture     Forum Help & Feedback Center     LucasForums Archive         LEGO Star Wars series         Star Wars         Star Wars: Battlefront series         Star Wars: Classic Gaming         Star Wars: Empire At War         Star Wars: The Force Unleashed series         Star Wars: Galaxies         Star Wars: Jedi Knight series         Star Wars: The Old Republic         Star Wars: Republic Commando         Star Wars: Rogue Squadron series         Star Wars: X-Wing series