"Stuart Peters" wrote in message
...
I know there is a way to do this I just can't figure it out.
Below is the lookup table.
I would like to enter a Hexidecimal number and have the program return all
the Fault descriptions that are applicable.
For instance If I enter the Hex value '2C'
I should get the following list:
General Fault Indicator
Temperature Indicator
Power Supply Indicator

Note: Fault value in column A in Hex
Fault value in lookup does not need to be Hex, but user input is always
hex

Fault Value Description
1 Mute Indicator
2 Frequency Unlock
4 Power Supply Indicator
8 Temperature Indicator
10 VSWR Fault Indicator
20 General Fault Indicator
40 Spare
80 Spare
100 Frequency Unlock with PS OK
200 10 MHz reference Fault
400 Temperature foldback at 85 degrees
800 Temperature Shutdown at 90 degrees
1000 VSWR foldback at 1.5
2000 VSWR shutdown at 2.5
4000 Spare
8000 Spare
10000 Bandpass Filter Fault
20000 Low RF Output Fault
40000 Final PA current 1 Fault
80000 Final PA current 2 Fault

It may be easiest to use the HEX2BIN function, and then split the bits in
the binary, perhaps with MID().
--
David Biddulph