vbax53854.xlsm
Sorry late in the game, but here is a userform and sheet solution.
I used a search button to change label captions based on selection from the list. (have the search item selected when you click search)
The userform loads all three columns but hides the last 2, then updates the captions when you click search.

On the sheet I used a data validation list and index/match to find the other 2 column values.

hope this helps

-mark