How to Combine Data in 2 Table of different Worksheets?

[ameenakbar]

I have two worksheet in excel file. in Sheet 1, there are Identity in Column A and Names on Column B. In Sheet 2 there is Identity in Column A and Score in Column B. There are 45000+ records (rows) in Sheet 1 and 22000+ records (rows) in Sheet 2. Mean Sheet 2 is half from Sheet 1. I want to put SCORE in Column C of Sheet 1. This column will half blank after completion, as its source is not complete. I dont want to use VLookup formula. That give nearest answer, but i want exact. I want that Identity which match from both sheets show in Column C of Sheet A. The Identity which are not in Sheet 2, show blank in Column C of Sheet A.

 

[ameenakbar]

Thanks Dear All, Thank you soo much.

 

[hiker95]

ameenakbar,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.