I have two worksheets:
1st Worksheet named, "Contact Master"
Contact Master
COMPANY Position Name
FD Roustabout Albarado, Justin
FD Welder Atchley, Brian
FD ABCO Bailey, Jason
2nd Worksheet named "Master Schedule"
Name Position
Arnold, Benjamin Roustabout
Sage, Richard Roustabout
I want to click on the name in contact master and have it take me to the
exact same name in the 2nd worksheet. When using hyperlink I am unable to
specify the specific name I want it to find.
Please help. I've been trying to figure this out for weeks. Vlookup and
Hlookup haven't worked.