Helper or Vlookup Help with rows and auto populating info

Occasional Contributor

Good Morning,

 

I have tried to figure out using helper or VLOOKUP in attempting to create a formula that would allow me to send information to another sheet when I select from a drop down. So far, I have only managed to to create a hyperlink between the sheets. I am looking to have the information from 3 cells in row to auto populate in 3 cells of another sheet when select from the drop down. Any help with this would amazing. 

2 Replies
YES!! You're a life saver.