I'm having a problem with a formula I'm trying to create. I have 7
different tests, lets call them A-G; that you can receive a 1,2,3, or 4
on. I want to create a formula that will identify what test and what
number was entered to kick back a value. So A-1 would have a different
value than A-4, likewise, D-2 would be different than B-2. I'm not sure
if this is possible to create a function of this length. If this would
be to long, are there any alternatives? Thanks in advance for the
help.


--
DVV
------------------------------------------------------------------------
DVV's Profile: http://www.excelforum.com/member.php...o&userid=30561
View this thread: http://www.excelforum.com/showthread...hreadid=502105