Compare Two sheet data

New Contributor

Hi All,

 

I have 2 excel sheet.

Sheet 1 & sheet 2

Sheet 1 I have bellow data.

Server name

Pc1

Pc2

Pc8

Sheet 2 i have bellow data.

Pc1.test.com

Pc2.test1.com

Pc8.test4.com

 

My question is, i need to compare sheet 1 to sheet 2. I need a results for sheet 1 with fqdn name.

 

If any function is there ?

 

 

 

 

 

 

 

 

0 Replies