Giving numers value to selections

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

=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)




the dude wrote:
>
> 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
>
> --
> the dude
> ------------------------------------------------------------------------
> the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
> View this thread: http://www.excelforum.com/showthread...hreadid=542506

--

Dave Peterson