Formula Help - Finding Value in Other Column

[Kenichi]

Say I have a list of current Contact #'s in column A. Column C and D are related, and in column C there are many Contract #'s and column D there are $ values.

I want a formula to search for each Contract # in column A in column C. If the contract # exists in column C, pull the $ value from column D and place it in column B. If the contract # in column A does not exist in column C, do nothing next to it in column B.

Is there a formula that can easily accomplish this?

If you need any clarification please let me know.

Thanks!

- Ryan

 

[mikerickson]

It sounds like VLOOKUP is what you want.