I have the foll prob, i have two worhsheets with values in column A matching
values in column C     A1 = 6 and  C1 = Cat
                A     B    C       
           1    6    Dog          Cat
           2    7    Pig           Rat
           3    17           x              y
Next sheet A30 = 6 and C30 = ?       
        A     B    C       
           30    6    fly             ?
           31    3    tin           can
           32   17           d             n
Can i write a formula in second worksheet to go look in first worksheet and
see the relationship between A1/C1 and get the value of C1 and make C32 = C1