IF AND formula help

[shdwfx]

I have attached an example of what I need to get to. Appreciate any help! We have multiple materials under the same "group". In reality, all of the materials should have the same Lower Temperature Limit if they all belong to the same group but of course this is not the case. So I need a formula that looks at the group number and the Lower Temp Limit.....is the group number the same, if so is the Lower Temp Limit the same? If yes, ok, if no, what is the missing value to be loaded. I hope this makes sense when you look at the attachment. Thanks for looking and again, really appreciate any help.

Michele

[boopathiraja]

HI, Try this in C2 and drag it down

=IF(COUNTIFS($A$2:$A$16,A2,$B$2:$B$16,B2)>=1,"OK",INDEX($B$2:$B$16,MATCH(A2,$A$2:$A$16,0)))

[shdwfx]

Thanks that's helpful but there has been a change to the request. It's not just as simple now as filling in blanks. I need to know now for all of the materials in the same group, where the data in the various columns conflicts. New attachment loaded which I hope explains it better. The gray highlighting was just for me to help me look at one group of materials at a time.