Thread: if function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bakhour bakhour is offline
external usenet poster
 
Posts: 1
Default 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?