Astor Posted October 9, 2008 Share Posted October 9, 2008 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. Link to comment Share on other sites More sharing options...
tk102 Posted October 9, 2008 Share Posted October 9, 2008 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) Link to comment Share on other sites More sharing options...
Astor Posted October 9, 2008 Author Share Posted October 9, 2008 I thought it might be a lookup function, but couldn't get it to work properly, until you just explained it! Thanks tk! Link to comment Share on other sites More sharing options...
Astrotoy7 Posted October 12, 2008 Share Posted October 12, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.