vba - Excel macro to search for value in a column and return a value on the same row from another co

I am trying to write a macro that will prompt the user to enter a value and do the following: - Search for the value in column B and select the first cell where the value is found - Return ...

stackoverflow.com