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