Forum Discussion
If Statement for Value Pasting to another Tab
Hi SergeiBaklan,
Thank you for the timely response. I have attached a sample file. I am attempting to transfer the contents of Tab 2 column 3 to cells in column 7 of Tab 1. The criteria for which the value should be transferred is whether the value in column 1 of the same row as the value to be transferred (In tab 2) contains at least two matching words with column 1 in tab 1.
Ie. Cell G3 of tab 1 should be populated with "Microsoft" by this logic.
Afraid that's not feasible with formulas - check if any two words in one texts contains in another text. That will require some programming. And for it logic is not clear, e.g. what consider as the word - any part of the text with space around, or it could be separated by slash, comma, etc. Plus possible misprint in texts as in your sample: Bald Mountian and Bald Mountain are not equal, to compare them fuzzy logic approach is required.
Other words as such that's not obvious and not simple task. Perhaps logic could be simplified, for example if return the value from tab 2 against text from it contains (as a full, not any parts of it) in tab 1, and to correct texts, that could be like
=INDEX('Tab 2'!$C$2:$C$5,XMATCH(1,--ISNUMBER(SEARCH('Tab 2'!$A$2:$A$5,$A$2:$A$3))))