find&replace macro
 

i need some help looking and replacing some stuff up...i cant seem to
come up with a combo of functions that work. what about a macro?

I need to find A1 in column B, then replace that cell in B with the
corresponding value in C1. (the find and replace in edit is soo tediuos

for 500+ searches)

A B C
1 5 9 33
2 6 3 41
3 9 6 423
4 5
5 7


i want something like this:
A B C
1 5 423 33
2 6 3 41
3 9 41 423
4 33
5 7

can someone help me! =o(