Advanced IF-THEN... Help Please

I've always wanted to do this, and I have a real need now so hopefully someone can help. I need a macro that looks at a column for a single ID, and then if it finds it returns the value of another column in the same row that ID resides in. The basic premise is as follows:

If Column A1:A6 = 4 then Row = X, get value Column C, Row X

A|B|C
-------
0|6|2
1|7|3
2|8|4
3|9|5
4|0|6
5|1|7

So the returned value wanted would be "6" in this example. Based on the row having a value of "5"

Im pretty sure this is doable, just unsure how to make it happen

Any help is much appreciated... I did try to search for this, but I'm a bit at a loss what specifically to look for

Thanks in advance!!

Thanks! I went with:

=VLOOKUP(A3,'SHEETNAME'!A:C,3,0)

Worked like a charm... seems I was making it more difficult than needed!

Thanks again.