LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Hexidecimal lookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get correct results when LOOKUP with calculated numbers onthemountain Excel Worksheet Functions 2 July 20th 06 01:13 AM
Another way to lookup data David Vollmer Excel Worksheet Functions 1 September 23rd 05 05:16 AM
Lookup Vector > Lookup Value Alec Kolundzic Excel Worksheet Functions 6 June 10th 05 02:14 PM
Lookup function w/Text and Year Josh O. Excel Worksheet Functions 1 February 12th 05 11:27 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"