Using the 'If' function to match two columns with the same first three letters of text

[Laurence D]

Hi all,

I just want to perform a quick quality check on some of my data and I am after a bit of help to make the proper formula as I keep getting too fewer arguments with my formula.

	A	B	C
1	Food Code	Food	Matches?
2	MARTOA	Marmite	Yes
3	JAMTOA	Jam	Yes
4	HONTOA	Marmite	No
5	CORMIL	Cornflakes	Yes

<tbody>
</tbody>

What I am after is an if formula that will search for the first three letters (to the left) of text in column A1 and see if matches with the first three letters (to the left) of text in column B1. Then if the columns matches to spit out in column C1 a "Yes" or if it does not match then "No".

Thanks,

Laurence

 

[footoo]

=IF(LEFT(A1,3)=LEFT(B1,3),"Yes","No")

 

[ttray33y]

you dont need if here, you just say

=[B]left(a2,3)=left(b2,3)

[/B]

excel will evaluate itself.

 

[footoo]

you dont need if here, you just say

=[B]left(a2,3)=left(b2,3)

[/B]

excel will evaluate itself.

Unless "Yes"/"No" is specifically needed rather than True/False

 

[ttray33y]

I see, thank you for the heads-up

 

[Laurence D]

Thanks team,

Wow I always seem to overcomplicate things when writing formulas...