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?