lfnetwork.com mark read register faq members calendar

Thread: Anyone good with excel?
Thread Tools Display Modes
Post a new thread. Add a reply to this thread. Indicate all threads in this forum as read. Subscribe to this forum. RSS feed: this forum RSS feed: all forums
Old 10-09-2008, 12:23 PM   #1
Astor
It's Thornhill!
 
Astor's Avatar
 
Status: Super Moderator
Join Date: Mar 2008
Location: Warwickshire, UK
Posts: 3,632
Current Game: The Old Republic
LFN Staff Member Forum Veteran Helpful! 
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.






Astor is offline   you may: quote & reply,
Old 10-09-2008, 03:08 PM   #2
tk102
Well past expiration date
 
tk102's Avatar
 
Join Date: Jan 2004
Posts: 5,766
Current Game: Dragon Age: Origins
Forum Veteran Helpful! Notable contributor 
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
 


tk102 is offline   you may: quote & reply,
Old 10-09-2008, 03:18 PM   #3
Astor
It's Thornhill!
 
Astor's Avatar
 
Status: Super Moderator
Join Date: Mar 2008
Location: Warwickshire, UK
Posts: 3,632
Current Game: The Old Republic
LFN Staff Member Forum Veteran Helpful! 
I thought it might be a lookup function, but couldn't get it to work properly, until you just explained it!

Thanks tk!






Astor is offline   you may: quote & reply,
Old 10-11-2008, 10:34 PM   #4
Astrotoy7
A Face from The Past
 
Astrotoy7's Avatar
 
Join Date: Apr 2002
Posts: 10,284
Notable contributor Helpful! Folder extraordinaire LFN Staff Member 
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
Astrotoy7 is offline   you may: quote & reply,
Post a new thread. Add a reply to this thread. Indicate all threads in this forum as read. Subscribe to this forum. RSS feed: this forum RSS feed: all forums
Go Back   LucasForums > Network > Community Discussion > General LFNetwork Forums > General Tech Discussion > Anyone good with excel?

Thread Tools
Display Modes

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 Jump


All times are GMT -4. The time now is 02:59 PM.

LFNetwork, LLC ©2002-2011 - All rights reserved.
Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.