Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2015, 10:01 AM
Strategic Strategic is offline Restrict data validation based upon a cell value Windows 7 64bit Restrict data validation based upon a cell value Office 2010 64bit
Novice
Restrict data validation based upon a cell value
 
Join Date: Jan 2015
Location: London
Posts: 2
Strategic is on a distinguished road
Question Restrict data validation based upon a cell value

Hi

I have been asked to put together a spreadsheet that involves data validation (no problem in its simple form).

But in this instance I only want to see a limited range of values from a large list, the values to be seen being determined from the entry in another cell.

In the example shown on the attachment I only want to be able to select Cost Heads that begin with the value of the last character in the Category i.e. "C" (started to look at using =right(A1,1) but limited by own knowledge.

Any thought on how to solve this issue would be gratefully received.

Thank you in advance


Strategic
Attached Files
File Type: pdf Excel limit data validation range.pdf (21.6 KB, 1 views)
Reply With Quote
  #2  
Old 01-26-2015, 07:53 AM
gebobs gebobs is offline Restrict data validation based upon a cell value Windows 7 64bit Restrict data validation based upon a cell value Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

http://www.contextures.com/xlDataVal02.html
Reply With Quote
  #3  
Old 01-27-2015, 02:13 AM
Strategic Strategic is offline Restrict data validation based upon a cell value Windows 7 64bit Restrict data validation based upon a cell value Office 2010 64bit
Novice
Restrict data validation based upon a cell value
 
Join Date: Jan 2015
Location: London
Posts: 2
Strategic is on a distinguished road
Default

Hi gebobs

Thanks for the response, I have had a quick look and this seems to hold the answer. Much appreciated.

Regards
Strategic
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restrict data validation based upon a cell value data validation from another sheet paulys Excel 1 06-30-2014 01:40 AM
Restrict data validation based upon a cell value Excel 2007, highlight entire row based on data found in one cell MSofficeBLUE Excel 2 10-15-2013 09:51 PM
Restrict data validation based upon a cell value Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
Restrict data validation based upon a cell value Data Validation drop down rkalapura Excel 1 05-27-2012 02:23 AM
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft