Related:
- Excel partial match two columns
- Excel match two columns and output third - Best answers
- Compare two columns in excel for partial matches - Best answers
- Perform a Partial Cell Match in Excel - How-To - Excel
- Partial Cell Match of Company Names in Excel ✓ - Forum - Excel
- Compare values in two columns and return the value from third ✓ - Forum - Excel
- Excel partial match ✓ - Forum - Excel
- Excel: Partial Matches in 2 Different Cells ✓ - Forum - Excel
1 reply
Blocked Profile
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!
Report
patallen8845
- Posts
- 2
- Registration date
- Monday October 22, 2018
- Status
- Member
- Last seen
- October 22, 2018
Thank you for the recommendation. I changed the logic flow to your recommendation =IF(MATCH("*"&LEFT(D2,15)&"*",$Z$2:$Z$432,0),D2) and it works like a charm--Logic is check the first 15 characters of data in column D against the data in column Z AND if there is a match then populate AA with the data in Column D and if there is no match then default to #NA. Thank you.
