Try this in C30

=VLOOKUP(A30,Sheet1!A1:C3,3,FALSE)

Mike

"whatzzup" wrote:

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