vipin30sep
New Member
- Joined
- Feb 14, 2019
- Messages
- 20
Hello,
The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the values correctly. Appreciate if you can help here. Thanks in advance!
<tbody>
</tbody>
The first column contains a string of values as mentioned below . In 2nd column, I need to strip out specific info from Col 1 (as mentioned below). I tried using a formula like this - =LOOKUP(MID(AS2,12,3),{"Lar","X-L"," Sma"},{"Large","X-Large","Small"}) , but its not calculating the values correctly. Appreciate if you can help here. Thanks in advance!
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | Mr. & Mrs. Large | ||
<tbody> </tbody> | Mr. & Mrs. Small | ||
<tbody> </tbody> | Mr. & Mrs. 2XL | ||
<tbody> </tbody> | Mr. & Mrs. Medium |
<tbody>
</tbody>