Giving numers value to selections

T

the dude

Hi guys,
I have a worksheet in which the cell A1 can have 3 different values
(yes, no, maybe) through the validation data option. I would like to
link the A1 cell to a cell B1 in another workbook, and I would like to
give a different number per every value (let's say that I want to have
the value 1 in B1 for the value "yes" in A1, 2 in B1 for the value "no"
in A1 and 3 in B1 for the value "maybe" in A1). How can I do that???
thanks a lot
the dude
 
D

Dave Peterson

=VLOOKUP(Sheet1!A1,{"yes",1;"no",2;"maybe",3},2,FALSE)

or

=VLOOKUP([book1.xls]Sheet1!A1,{"yes",1;"no",2;"maybe",3},2,FALSE)
 
Top