changing cell value depending on list selection

[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

 

[Andy B]

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.

 

[robert_woodie]

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

 

[Andy B]

Robert

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

Andy.

 

[Frank Kabel]

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)