How can I use a value of a cell in a formula?

For example:

A B C
test.com 2
test1.com 1
test3.com 3

in cell C1, if lookup the text result of a cell in Column A which correspnds
to value of Column B.
--
Fred K.