Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Giving numers value to selections
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel hangs after giving File Open | Excel Discussion (Misc queries) | |||
nonadjacent selections | Excel Worksheet Functions | |||
ActiveCell giving blank value | New Users to Excel | |||
ActiveCell giving blank value in vbscript | Excel Worksheet Functions | |||
excell 2000 is giving an error "not enough memory" | Excel Discussion (Misc queries) |