if function
 

I have multiple sheets on the same workbook that contains the same values but
differant sortings meaning, the cell might exist in all or some of the sheets
available.
When i tried to use the "if" function to find info in one cell that contains
the vlue i wanna add to the same array on differant sheets, it worked for
some only and not all.
I think that this function works perfectly when all sheets are arranged and
sorted the same way. But if they are not! what to do?