Comparing two columns using partial match logic
Solved/Closed
patallen8845
Posts
2
Registration date
Monday October 22, 2018
Status
Member
Last seen
October 22, 2018

Oct 22, 2018 at 03:09 PM
patallen8845 Posts 2 Registration date Monday October 22, 2018 Status Member Last seen October 22, 2018  Oct 22, 2018 at 05:52 PM
patallen8845 Posts 2 Registration date Monday October 22, 2018 Status Member Last seen October 22, 2018  Oct 22, 2018 at 05:52 PM
Related:
 Comparing two columns using partial match logic
 Logic pro x free download  Download  Musical production
 Excel compare two columns for partial matches  Guide
 Excel intersection of two columns  Excel Forum
 If two cells match return value from third excel ✓  Excel Forum
 Display two columns in data validation list but return only one  Guide
1 response
It is the second blank entry between the " ".
=IF(MATCH("*"&LEFT(D2,D15)&"*",$Z$Z2:$Z$432,0),AA,D2)
^^^^
If syntax is:
If we break down your formula, we get:
If(
MATCH("*"&LEFT(D2,D15)&"*",$Z$Z2:$Z$432,0) //Logic_statement
" ", //True
D2) //False
Have fun!
=IF(MATCH("*"&LEFT(D2,D15)&"*",$Z$Z2:$Z$432,0),AA,D2)
^^^^
If syntax is:
=If(Logic_statement, true, false)
If we break down your formula, we get:
If(
MATCH("*"&LEFT(D2,D15)&"*",$Z$Z2:$Z$432,0) //Logic_statement
" ", //True
D2) //False
Have fun!
Oct 22, 2018 at 05:52 PM