Ron Rosenfeld wrote...
On 21 Jul 2006 14:58:40 -0700, "Harlan Grove" wrote:
Stuart Peters wrote...
....
I should get the following list:
General Fault Indicator
Temperature Indicator
Power Supply Indicator
....

This list is vertical.

H4:
=IF(IF(H3<"",MOD(HEX2DEC($G$3),HEX2DEC(INDEX($A $2:$A$21,MATCH(H3,
$B$2:$B$21,0))))),LOOKUP(DEC2HEX(MOD(HEX2DEC($G$ 3),
HEX2DEC(INDEX($A$2:$A$21,MATCH(H3,$B$2:$B$21,0)) )),5),
RIGHT("00000"&$A$2:$A$21,5),$B$2:$B$21),"")

Fill H4 down into H5:H22 to cover fault code entry of FFFFF.

Maybe Fill Right?

How does one fill H4 *right* into H5:H22? How does filling right
produce a vertical list?