Creating a form

[bino547]

I have a worksheet that has a field allowing for a user to enter a part #. However, I would like for a description of the item to appear in the adjacent cell once the user enters a code. Example of my master list:


Part # Description
1 hammer
2 screwdriver
3 wrench
4 tape

If you can assist me with this I would greatly appreciate it

 

[ranman256]

VLOOKUP( value, table, index_number)

value = cell of part#
table = range of inventory:A1:B6
index_number = return column

VLOOKUP(a2, Y1:Z6, 2) lookup part# in cell A2, in table Y1:Z6, return what is in column 2

 

[bino547]

Thanks!

Will VLookup also allow for me enter a default message like, "Enter a part # in the box to the left"?