MATCH first 7 of one cell with first 7 of another cell

[Sphinx404]

I'm trying to figure out how to properly input a formula that will match the first 7 characters of C2, with the first 7 characters of A2.

=IF(ISNUMBER(MATCH(LEFT(C2,7..........),true,false)

Not sure if I'm on the right track.

I'm confused with using "ISNUMBER" because I'm not looking for a number per-say... It can be numbers and/or characters. IDEAS?

 

[admiral100]

Hi,

Try this :

=IF(LEFT(A2,7)=LEFT(C2,7),"Match","No match")

 

[Sphinx404]

Hi,

Try this :

=IF(LEFT(A2,7)=LEFT(C2,7),"Match","No match")

Perfect. Thank you!

 

[admiral100]

You are welcome, thank you for the feedbak