#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Hi gebobs
Thanks for the response, I have had a quick look and this seems to hold the answer. Much appreciated. Regards Strategic |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
data validation from another sheet | paulys | Excel | 1 | 06-30-2014 01:40 AM |
Excel 2007, highlight entire row based on data found in one cell | MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
Creating formula based on if data is correct in cell | MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
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 |