How to find matching values in two excel sheet

[anon87560229]

hi @Raja.G
Please find below topic this may help you to reslove you question ,

How to compare two excel sheet & update the matched value in sheet 2

Hi all, I have 2 worksheets, In sheet 1 it holds ID & Amount and in sheet 2 it has only ID. I have to compare both sheet & If Id matched I want to get the amount and write in sheet 2, example, Worksheet A ID Amount 1111 $123 2222 $678 3333 $980 4444 $650 Worksheet B ID Amount 1111 $123 5555 3333 $980 0444 Thanks in advance

Regards
Mohini
Happy Automtaion …