mkx

Can anyone help me with this excel command? I have a list of about 50 domains that are soon to expire in Sheet 1 column A, and my domain parking stats in Sheet 2 which display the domain name in Column A, Revenue Column B, Views Column C, and Clicks Column D. Rather than use the find command individually which I have been doing for the last 5 years, can I just match it up,

Basically in sheet 1 column B it would say:
If sheet 1 column a = sheet 2 column A, sheet1 column B = sheet 2 column B
etc

Hope someone can help