Return value of culumn C if both column A &column B match a condition?

Question

I have data in column A, B, and C. I want to search text "X" in column A and search text "Y" in column B, if in the same raw, column A ="X", and column B = "Y", then I want the value of column C. (if "X" and "Y" are not in the same raw, that's not wanted)
Please help!

In Excel, I mean, I don't know any computer language.
Thanks.

Thanks for the first 3 answers! But the problem is not solved yet, --sorry, I didn't make my question clear. Here it is:
A B C D
w xy 1 D1=search A and B to find
x wz 2 "wx", return "3" in D1
y wx 3
z xz 4

Answer 1

Assuming u are referring to columns in MS-Excel, then use the following command
=IF(AND(FIND("aa",A2,1)>0, FIND("aa",B2,1)>0),"Yes","No")

Where "aa" -> is the text to be found
Cell Address "A2" is the text in which "aa" is searched
AND(condition1,condition2) gives true if both the conditions are YES, i.e. required text is available in the string being searched.

Answer 2

There are two methods of cell dressing in Excel. One relative and one absolute, you have to select the relative one (as the absolute one is the default). There's some jargon they use for them both. It's some time since I've played with Excel but the switch is in Tools->Options->General and the box is R1C1 and then you can address a column relative to the current column. C[-1] (the last column) or something like that.

Answer 3

Which language are you using? C? C++?

Answer 4

I believe you are looking for SQL?

SELECT T.C
FROM TABLE_NAME T
WHERE T.A LIKE "%X%"
AND T.B LIKE "%Y%"