mohdamir1989
New Member
- Joined
- Oct 17, 2017
- Messages
- 42
Hi All,
Is it possible to lookup a string of numbers in any cell from other workbook and result in the corresponding text (Excel 2007)
Thank you in advance.
For example:
<tbody>
</tbody>
Helper Sheet
<colgroup><col><col></colgroup><tbody>
</tbody>
Is it possible to lookup a string of numbers in any cell from other workbook and result in the corresponding text (Excel 2007)
Thank you in advance.
For example:
Lookup Cell | Result |
1, 2, 4, 12, 14 | Relay burnt, Capacitor Burnt, Suction Joint Gas leak, Overload burnt, Thermostat dead |
<tbody>
</tbody>
Helper Sheet
Sr No. | Fault & Diagnosing |
1 | Relay burnt |
2 | Capacitor burnt |
4 | Suction Joint Gas leak |
5 | 1/3 Compressor low pressure |
6 | 1/4 Compressor ceased |
7 | 1/3 Condenser Leak |
8 | Capillary broken |
9 | Voltage problem |
10 | Suction Joint Gas leak |
11 | Gas leak |
12 | Overload Burnt |
13 | Overlaod faulty |
14 | Thermostat dead |
<colgroup><col><col></colgroup><tbody>
</tbody>