Forum Discussion

jacksoncheyne's avatar
jacksoncheyne
Copper Contributor
May 21, 2019

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 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

excel

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 21, 2019
    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!

Resources