Simple Excel VBA Help

[A[L]C]

Having a mind block. I need some code to search column A for a specific string and return the value of the cell to the right of it ie

String = test

test is in cell A5 - I need the value of cell B5.

Thanks

 

[A[L]C]

thanks, but I need to do it inside a vba macro.