Data Validation

  • Thread starter Thread starter zero635
  • Start date Start date
Z

zero635

Is it possible to have a data validation list to control the out come of
another column?

For example:
Columns
A B
1 1 name1
2 2 name2
3 3 name3
4 4 name4
5 5 name5
6 6 name6

with the above example, what I am asking is it possible to select the
number in column A and have it automatically place in column B the name
that belongs to that number? I hope this is clear.

Thank You,
Chris
 
That would be VLOOKUP not Data Validation.

Put the values in say M1:M10, the names in N1:N10 and then in B1

=VLOOKUP(A1,$M$1:$N$10,2,False)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Bob,

Thanks for the response. This has got me on the right path. I was
trying to work this out for a coworker and I think this my do it for
him. Again, I really appreciate the help.

Chris:)
 
Bob,

sorry, one quick question about the Vlookup. Is there a way to keep
the "#n/a" from appearing when a value hasn't been selected?

Thanks again,
Chris:)
 
=VLOOKUP(A1,$M$1:$N$10,2,False)
becomes:
=if(a1="","",if(iserror(vlookup(....)),"",vlookup(....)))
 
Back
Top