May 21 2019 06:50 PM
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
May 21 2019 08:36 PM
May 21 2019 08:56 PM