First of all can I apologise, I can read and understand formulas, but find it hard to write them.
I require a formula to return a value from a row (in a table) on another worksheet (Tab 1), where the table has partial text.
Tab 3 has full text (in cell) that I require the result to be copied.
The way I see the formula is :-
Tab3 cell U4 = Tab1 P:P (if Tab1 column C:C (partial text) is contained in Tab3 cell C4 (full text).
Hope this is clear.
<colgroup><col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;">
<col width="64" style="width: 48pt;" span="13">
<col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;">
<col width="64" style="width: 48pt;" span="2">
<tbody>
</tbody>
I have been searching for a formula/help for the last 3 days, before finally registering on here for help.
Thank you in advance
Tia
I require a formula to return a value from a row (in a table) on another worksheet (Tab 1), where the table has partial text.
Tab 3 has full text (in cell) that I require the result to be copied.
The way I see the formula is :-
Tab3 cell U4 = Tab1 P:P (if Tab1 column C:C (partial text) is contained in Tab3 cell C4 (full text).
Hope this is clear.
Tab 3 | Tab 1 | |||||||||||||||
Full info | Partial info | |||||||||||||||
68974-41101 | This cell to return value of | 41101 | Printed | |||||||||||||
68974-41103 | columnF in tab 1, if tab 1 column B:B | 41102 | Printed | |||||||||||||
68974-41315 | is contained within tab 3 column A | 41103 | Ready to print | |||||||||||||
68974-41102 | 41104 | Held | ||||||||||||||
68974-41416 | 41105 | Started | ||||||||||||||
68974-61116 | 41106 | Not allocated | ||||||||||||||
68974-41614 | 41107 | Complete | ||||||||||||||
68974-41108 | 41108 | Printed | ||||||||||||||
68974-41190 | 41109 | Not allocated | ||||||||||||||
68974-41117 | 41110 | Not allocated | ||||||||||||||
68974-41150 | 41111 | Not allocated | ||||||||||||||
68974-41111 | 41112 | Held | ||||||||||||||
68974-41112 | 41113 | Held | ||||||||||||||
68974-41104 | 41114 | Started | ||||||||||||||
68974-41713 | 41115 | Complete | ||||||||||||||
68974-41174 | 41116 | Complete | ||||||||||||||
68974-47115 | 41117 | Started | ||||||||||||||
I have been searching for a formula/help for the last 3 days, before finally registering on here for help.
Thank you in advance
Tia