Auto populate adjacent cells from a drop down list

Hello.

Did some searching and got somewhere, but not far enough.

On the attached workbook, on the purchases sheet, i need to get the item number to auto populate. The item is from the inventory sheet, along with the item number.


Second bonus question, how do i get the drop down list to predict what i want, from the first few letters i type, for instance when i type H i want to see "Hitachi 1-1/4" - 1-3/4" Coil Gun"

Thanks a bunch!

You need this for A11 and down:

=IF(B11="","",INDEX(Inventory!B:B,MATCH(B11,Inventory!C:C,0)))

For the bonus question, read this: http://www.excelforum.com/excel-gene...own-lists.html

Well, thats how you do it!!!

I see the direction of the bonus question but it is lower priority for now and just out of my grasp... I will ask again when i need clarification.

Thanks.

You're welcome. Thanks for the 'star tap'.