gobblechops
New Member
- Joined
- Apr 27, 2017
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
Hi,
Column A contains descriptions.
A table in columns E to F, contains... Part texts in column E, contains values to return in column F.
Column B requires the formula. E.g Formula required in Cell B1..... Look in column E (table) for any part text contained in the full text of cell A1, if finding a matching part text, return corresponding value in column F of (table).
Thanks!
Column A contains descriptions.
A table in columns E to F, contains... Part texts in column E, contains values to return in column F.
Column B requires the formula. E.g Formula required in Cell B1..... Look in column E (table) for any part text contained in the full text of cell A1, if finding a matching part text, return corresponding value in column F of (table).
Thanks!