How do I...?

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

Guest

If i have a cell C18 with list values "25-51-91","25-51-82","25-51-54"
"25-51-55","25-50-23"

and a cell c19 with list values"0", "1", "E"

and when i select "25-51-91" cell c19 value should be 0
when i select 25-51-82,25-51-54,25-51-55 cell c19 value should be 1
when i select 25-50-23 c19 value should be E

How can i get it automatically done? so that when i select the value for c18
the value to c19 is auto generated ?


Yvannia
 
Is this data|Validation in C18?

If you limit the values in C18, you could use a formula in C19:

=if(c18="","",if(c18="25-51-91",0,if(c18="25-50-23","E",1)))

or you could be more explicit:

=IF(C18="","",IF(C18="25-51-91",0,IF(C18="25-50-23","E",
IF(OR(C18={"25-51-82","25-51-54","25-51-55"}),1,"whatgoeshere"))))

(all one cell)
 
I hope you are familiar with vlookup or hlookup, because that function
would be able to do what you want.
 

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

how do i do 3 data validations? 2
Average Value 34
WCG Stats Wednesday 07 December 2022 3
Function to format a value into percent with no decimal 3
Fill cells increment row number i fomula 1
How to get the array like this? 6
WCG Stats Monday 05 December 2022 3
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Back
Top