No.

Any vlookup with the key ABACAVIR will ALWAYS result in the FIRST entry
of ABACAVIR to be selected.

For dependent Listboxes look at this:

http://www.contextures.com/xlDataVal02.html

Alternatively you can use Autofilter to select what you need from the
above table.

Hans