DATA VALIDATION with LEFT function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use a data validation – List and enter only the first
character from that list.
For example my list is below and named “Typesâ€

C - Construction
D – Demolition
E – Equipment Installation
R – Repair

The cell to be filled only needs the first letter not the whole content of
the list.
I try to use LEFT function in the Validation Source and I can not make it
work with
The name source “=Left(=Types,1)â€
Can someone help or suggest a different way use the data validation, like
use two columns display the description in one and enter data from the other.

Thanks.
 
Sounds like you need a combobox or list box,and tie some code to the
selection to get the value. Or else you could put the LEFT formula result in
another cell altogether.
 
try setting up three columns
one with the initials
one with the full description
and one with an if statement to select back and forth between the initials
and the description
in your list select the equation section.
Next to your lookup put in a selection button to toggle back and forth on
your if statements.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation 3
Data Validation 1
Indirect function and data validation dropdown box 2
Data Validation-VLOOKUP 1
Data validation on data validation function 1
Data Validation List with blanks 1
If formula and Data Validation parallely 1

Back
Top