Forum Discussion
Confirming if a cell matches another using a vlookup
Hey guys, Just looking for some assistance with pulling data from one cell into another - the example would be as follows: Cell A1: ABC Brisbane Cell B1: Brisbane I'm trying to generate a form...
You can use a formula with (or without) wildcard characters, like this:
With wildcard:
=IF(COUNTIF(A1,"*"&B1&"*"),
"Match",
"No Match")
Without wildcard:
=IF(ISNUMBER(SEARCH(B1,A1)),
"Match",
"No Match")
The choice is yours!
With wildcard:
=IF(COUNTIF(A1,"*"&B1&"*"),
"Match",
"No Match")
Without wildcard:
=IF(ISNUMBER(SEARCH(B1,A1)),
"Match",
"No Match")
The choice is yours!