I need a bit of help finishing of this formula:
=IF(ISERROR(MATCH("*"&C2&"*",B:B,0)),"False","True")
I have a list of addresses some with multiple In one cell, with a lot containing a postcode at the end. I have a separate list of postcodes that I have searched on using the wildcard function. So I can get whether somewhere in my list their is a matching postcode in the first list. I then have to match up the unique reference (column A) with my list of postcodes. This is the sample data(I have separated the columns using -):
LA77648 - 22 Dane Street, Burnley (BB10 1AB) - BB10 4QL - True
LA80291 - 74 Burns Street, Burnley (BB12 0AJ) - BB10 3EZ - False
LA81235 - 76 Westgate, Burnley (BB11 1RY) - BB12 8HY - False
LA87469 - 17 Branch Road, Burnley (BB11 3AT) - BB11 5HT - False
This is so close to what I want but I need another column after the True/False to copy the relevant matching cell. I then need the next column to show me the cell in column A that matches the matching cell in column B. I have tried Index, VLookup, Matches, Formatting and everything else I can think of.
This is an example of what I need it to look like (done manually):
BB11 3JA - True - 2 St Stephens Street, Burnley (BB11 3JA) - LA123865
BB12 0NL - True - 4 Cairo Street, Burnley (BB12 0NL) - LA297035