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

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