Looking for a formula that matches 2 sets of data

[Statz]

This is the problem I'm having.

I run a report that displays information. For example, report A shows that Diet Pepsi is in the retail account and this information is generated from the user as they manually check off a box saying "yes" it's in the account. I need a way to cross reference whether it's a true fact or not. Internally I can run a sales report that shows what the account has in it. Problem is it's not a feasible practice for 2000 accounts.

I was hoping to find a way to export the information of what the user enters in his computer and then have it match up with some internal sales reports. The problem is that while report A shows "Diet Pepsi" as a line item. The sales report is written a little different. I.e. Diet Pepsi 101 (even though they are the same).

Ultimately the goal is that if Report A is saying the account has Diet Pepsi and our internal sales reports show no evidence of it. I get a #NA of some sort. Which would mean false information is being entered. Therefore not accurate and the user is either lying or mistakenly putting something different.

I think the type of formula I am looking for is Iferror but never have used this or understand how it works.

[samba_ravi]

pls attach sample excel file

[Statz]

Thanks for responding. I finally have time to jump back into this problem. I attached a file I created in 2013. 3 work sheets/tabs.

First tab is manually entered information from another computer. This data comes from employees entering data by selecting choices.
2nd tab is actual sales data from our report program.
3rd tab is a comparison of the same results but listed 2 different ways because of the 2 different sources of getting this info (see tab 1 & 2)

So what I need is for every time column D in tab 1 list a certain name it cross checks in tab 2 column C to see if the same is there. If it can't find it on tab 2 show some type of #N/A or something showing an error. This will be how we find out if the information is false. Trying to find a way to verify real sales data vs what an employee is saying is there.

[FDibbins]

Not sure I get your links, but try this in D, copied down...
=MATCH(C2&"*",'Sales Data'!$C$2:$C$9,0)

[Statz]

Thanks for responding. I tried your suggestion but not sure what's going on. I attached a copy with the formula in there. I entered text in column C and it still gave me an answer of "1" even though there is no data in column A. I need to make sure column A that list the account name is factored into these and it's not simply comparing 2 columns. Doesn't look your formula is factoring in my comparison tab. I deleted all the info there and it doesn't change anything. It's possible I guess that I don't need it but would think that I'd need to establish 2 variables and let the page know which one I care about.