how to do a partial MATCH?

[rpetrie]

Hi,
I am trying to find a way of identifying a partial match between two bits of text.

at present I am using the MATCH function to identify if an email address already exists in another sheet.
In other words check if there is a match for [email protected] in sheet2

I am using this formula =IFERROR(MATCH(F2,sheet2!$A$1:$A$4500,0),None)

Now I want to check for *@fredsshop.com. In other words I want to do a partial match.

Can anyone advise me how to change this formula to do this?

Many Thanks,

Richard

[DonkeyOte]

For the specific example

=IFERROR(MATCH(REPLACE(F2,1,FIND("@",F2),"*"),sheet2!$A$1:$A$4500,0),"None")

[rpetrie]

Hi Donkeyote,
thanks for your reply - really appreciated.
So would this give a positive match to the examples of [email protected] and also [email protected]?

I'm not sure if I was clear enough but this is what I need to achieve.

Once again, thanks for your help.

Richard

[DonkeyOte]

It was unclear as to what the content of F2 was but in essence the formula will conduct a partial match in so far as it will look for anything@fredshop.com in Sheet2!A1:A4500

(assumes F2 contains an address with the relevant domain - eg [email protected])

If in doubt test... if you're not getting the desired results best to post a sample file illustrating as such.