Hi Friends,

I have excel sheet with four columns in the first sheet (1st 3 coulmns has the data and the 4th column is the result). I have another excel sheet (1st 3 coulmns has the data and need to print the 4th column from 1st sheet 4th column).

SHEET1

Platform Os Name OsMinVersion OsMaxVersion Os Name
Alpha Win NT 0.00.0000.0 99.99.9999.9999 All Alpha NT
Alpha Win NT 3.51.0000.0 3.51.9999.9999 All Alpha NT 3.51
Alpha Win NT 3.51.1057.0 3.51.1057.0 Alpha NT 3.51 original release
Alpha Win NT 3.51.1057.1 3.51.1057.1 Alpha NT 3.51 Service Pack 1
Alpha Win NT 3.51.1057.2 3.51.1057.2 Alpha NT 3.51 Service Pack 2
Alpha Win NT 3.51.1057.3 3.51.1057.3 Alpha NT 3.51 Service Pack 3
Alpha Win NT 3.51.1057.4 3.51.1057.4 Alpha NT 3.51 Service Pack 4
Alpha Win NT 3.51.1057.5 3.51.1057.5 Alpha NT 3.51 Service Pack 5

SHEET2

Platform Os Name OsMinVersion OsMaxVersion
I386 Win NT 6.00.6002.2 6.00.9999.2
I386 Win NT 5.10.2600.3 5.10.2600.3
I386 Win NT 6.00.6002.2 6.00.9999.2
I386 Win NT 5.10.0000.0 5.10.9999.9999
I386 Win NT 6.00.0000.0 6.00.9999.9999
I386 Win NT 5.20.0000.0 5.20.9999.9999
I386 Win NT 5.00.2195.4 5.00.2195.4
I386 Win NT 5.00.2195.4 5.00.2195.4
I386 Win NT 5.10.0000.0 5.10.9999.9999


Now i should compare 1st four column on both and if it is identical, it should give the value of respective 4th column(OS Name) from Sheet1 to sheet2.