Find data and copy adjacent cell

I need help writing a VBA macro, that finds a certain value or text within a column, and then assigns the corresponding information in the adjacent columns, in that row to variables.

How can I do this?

Here is what I have so far:

Please Login or Register  to view this content.

This works, however if there are more than one value in C:C that equal Volts.Text, I need to be able to select those as well, and put them in other variables.