Hello all and thank you for your help.
I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes.
I need to perform the following functions and return a single value:
1) Search a text string in a single cell to confirm certain text is contained in the string
2) If said text is found, return a numerical value from a table with matching text string
Here is the example text string (all contained in one cell):
<tbody>
</tbody>
I would like to confirm whether the text string has an "FW" or "SW" within the text string. The text string will not always be in the same spot.
<tbody>
</tbody>
Also, I will need to be able to search other text strings with other values, but I thought this would be enough to get started.
Excel Version 14.0 32-bit version
Thank you
I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes.
I need to perform the following functions and return a single value:
1) Search a text string in a single cell to confirm certain text is contained in the string
2) If said text is found, return a numerical value from a table with matching text string
Here is the example text string (all contained in one cell):
CAT18-EC-FW-FGP, LW, SDE, NOF, FG, RHS, PLBR |
<tbody>
</tbody>
I would like to confirm whether the text string has an "FW" or "SW" within the text string. The text string will not always be in the same spot.
String | Value |
FW | 0 |
SW | 1 |
<tbody>
</tbody>
Also, I will need to be able to search other text strings with other values, but I thought this would be enough to get started.
Excel Version 14.0 32-bit version
Thank you