Need help matching data

[RoccoM83]

hi

i have two spreadsheets downloaded from separate systems.

the first list has
order number and an amount
the order number is on each list multiple times with different values for item ordered.

the second list has the same but some of the values are different

how can i do a search to find if the data of sheet one match the data on sheet 2?
i need to match each line of the order numbers to see if they have same value on the other sheet.

sorry my explanation is not great

thanks​

 

[levy77]

Hi Rocco,

I used a vlookup to return the vale of the order from list 2 and put that value next to list one. I then used a simple If function to return "Yes" if they were the same and "No" if they were different.

The formula looked like this =IF(B2=VLOOKUP(A2,Sheet2!$A$2:$B$11,2),"Yes","No").
With the order numbers in column A and order amounts in column B.

Let me know if this works for you.

 

[hiker95]

RoccoM83,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try one of the following:

Click on the below link to see How to display your sheet, and, how to install, download, and, use the MrExcel HTML Maker:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html


It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

 

[RoccoM83]

Hi thanks for that but didnt work for me
is there a way to upload a file ?

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	A	B	C
1	ID	Amount	Match ?
2	336A	$ 34.00	Match
3	352A	$ 78.00	No Match
4	325A	$ 43.00	Match
5	309A	$ 21.00	Match
6	325A	$ 67.00	No Match
7	477A	$ 54.00	Match
8	336A	$ 87.00	No Match
9	195A	$ 46.00	No Match
10	336A	$ 34.00	Match
11	333A	$ 76.00	No Match
12	441A	$ 45.00	Match
Sheet1

Excel Workbook
	A	B
1	ID	Amount
2	309A	$ 21.00
3	325A	$ 23.00
4	336A	$ 25.00
5	336A	$ 34.00
6	352A	$ 36.00
7	336A	$ 36.00
8	325A	$ 43.00
9	195A	$ 45.00
10	441A	$ 45.00
11	477A	$ 54.00
12	333A	$ 75.00
Sheet2

 

[Joe4]

Cross-posted here: https://www.excelforum.com/excel-fo...615-help-with-formula-to-match-find-data.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[levy77]

Here is the sheet Rocco https://drive.google.com/open?id=1-hGyljVDfptA9M1qjlABBhkn1aTIfUUl

 

[RoccoM83]

thanks for the help guys