Confirming if a cell matches another using a vlookup

Copper Contributor

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 formula that will check if the word 'Brisbane' is present in the first cell... My current formula, which hasn't worked, is as follows:

=IF(VLOOKUP(B1,A1,1)=B1,"Match","No Match")

Where am I going wrong? This formula returns a 'No Match' no matter the cell

 

Thanks in advance

2 Replies

@jacksoncheyne 

It is more something like:

=IF(COUNTIFS(A1,"*"&B1);"";"No ")&"Match"

Untested.

 

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!