Using several dropdowns suggests the user picks all the items. If you
want to do this, you need to have the choices elsewhere, and the
dropdown can reference them.

Vlookup would be if you want the user to make one choice and the other
columns to automatically give other info. Also, it can only look up
one thing and return one thing. So if you are trying to use 3
dropdowns and then reference those 3 items to put data elsewhere, you
may need a different formula than vlookup to do it.

So....what exactly are you trying to do?