I'm not sure if VLookup is the process I'm looking for, but if it is, I
can't figure out a way to get it to work. My scenario is this:

I have information listed in 3 columns: Name, Address, Phone. I want to
use a UserForm to search these columns and display the info.

If a user searches via column A (Name) and it matches, the results show the
address and phone. If the user searches via column B (Address) and it
matches, the results show Name and Phone, as well. Same goes if the user
searches column C for Phone.

Can someone help me or direct me in the right direction to accomplish this
task? Any help would be truly appreciated.

Mark