changing cell value depending on list selection

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

I have a long coloumn of data which is entered by selecting from a dro
down list (data/validation/list)i want a numerical value to b
associated with each value from the drop down list. I would also lik
this value to be dependent on another value in another cell.

ie:

A B C
one build 1
two
three build 2

Coloumns A and B are drop down lists and C is a numerical value tha
appears only when Build is in coloumn B and the value depends on wha
is entered in coloumn A.

Hope this isnt too confusing!

Thanks
Rober
 
Robert

You have a few options. If there are only a few values that could go in
column C you can use nested ifs. An alternative is to create a lookup table
and use VLOOKUP() to return the correct data.

Hope this helps.

Andy.
 
if i was to use a lookup table how do i get it to lookup 2 values. Ie
value in colomn 1 must be 'A' but there must also be a 'B' in colomn
then the result is coloumn 3. The lookup table is essentially using t
lookup values
 
Robert

You'd need two tables and nest your VLOOKUP()s together into one cell. It
sounds complex but it's fairly straightforward.

Andy.
 
Hi
try the following (if A1 and B1 are your lookup values
=INDEX('lookup'!C1:C100,MATCH(A1&B1,'lookup'!A1:A100&'lookup'!B1:B100,0
))
enter this as array formula (CTRL+SHIFT+ENTER)
 
Back
Top