Link to data from a dropdown list

Hello,

I am attempting to link from a list in a table to matching data on a different sheet in a work book. In the sample I have attached, you will see I have to sheets, Vendors and Jobs. On the "jobs" sheet I have a table with contract information. One column is the name of the vendor being used which is selected from a dropdown list sourced from the "vendors " sheet. What I would like to do is make the selection a link back to the correct row of information on the "vedors" sheet where additional information about the vendor will be found.

Thanks for your help!

Thank you ORoos!

However, I want to try and make the vendor name from the dropdown list in B2 a link. I was trying to avoid adding another column.

v/r,
John