Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 Thanks, Stuart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |