Can vlookup return two values and give user an option to select list like data validation

Hey guys, i was wondering if anyone can help me write a formula to possibly make this work. I want to have a user select from a list drop down menu for cell B18 one tool. I have a seperate sheet with tools and serial numbers. I was wondering if there is a way to write a vlookup formula so I can choose between the different options for serial numbers for that tool. Currently I have this =IFERROR(VLOOKUP('BHA(1)'!B16,Inventory!C14:N56,4,FALSE),"") written up but it just sends back the first occurrence serial number of the tool. Any help would be greatly appreciated. Thanks

I think you would be better off having two data validation drop-downs, where the second list automatically adjusts depending on what you have chosen from the first. This is known as dependent data validation, and is described by Debra Dalgleish on her website here:

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

Hope this helps.

Pete