Try this alternative for your intents:
=IF(H55="","",IF(ISNUMBER(MATCH(H55,{"A";"B";"C";" D";"E"},0)),VLOOKUP(H55,{"A",2;"B",4;"C",6;"D",8;" E",10},2,0),"Z"))

In your posted formula, text (eg: "A", "B") should appear within double
quotes, numbers without. You had it mixed up.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"KAY" wrote:
What is wrong with the function?
=IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z")))))
Thank you for your help!
Karen