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:
- Excel compare two columns for partial matches
- Excel apk for pc - Download - Spreadsheets
- Beyond compare - Download - File management
- Kernel for excel - Download - Backup and recovery
- Display two columns in data validation list but return only one - Guide
- Excel marksheet - 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