One way is to use VLOOKUP
(with the 4th param set to zero for exact match)

First, set up a reference table array
in say: Sheet1's cols A and B, eg:

hello 100
help 300
test 500
bye 700
etc

Then in any other sheet, we could use:
in D6: =VLOOKUP(D5,Sheet1!$A:$B,2,0)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Moh" wrote:
how can i get a multiple answers from one cell to another.

Example my output cell will be d6
if cell d5 says hello then d6 will say 100
if cell d5 says help then d6 will say 300
if cell d5 says test then d6 will say 500
if cell d5 says bye then d6 will say 700
etc..


i got one but its only for two answers, i need at least 20
=IF(A1="Pass",100,IF(A1="Fail",0,""))

Please help !!!!!!!


--
Moh
------------------------------------------------------------------------
Moh's Profile: http://www.excelforum.com/member.php...o&userid=35434
View this thread: http://www.excelforum.com/showthread...hreadid=552060