OT Microsoft excel help

[nicholas1986]

Hi i would like find out if there is a function in excel that allows the user to type a certain product number and all in the info about the product comes out.
for example i am typing in a tempory loan form.
the usual step will be to copy the item name and item number into the respective box
the item name and number comes in a pair.
is there something that i can insert into the form that allows me to search by item name then the number will appear.
i know that access can do it but my form format is in excel.

any ideas?

 

[Del_CtrlnoAlt]

excel is a spreadsheet, not a database program...

 

[zac08]

Try using the command Vlookup

 

[Darren]

You can use a combination of a data validation list and the vlookup function.

See example Excel file linked here :-

http://darren.clubsnap.org/files/form_list_lookup.xls

Excel consultation and form-creation is available for a fee

 

[nicholas1986]

You can use a combination of a data validation list and the vlookup function.

See example Excel file linked here :-

http://darren.clubsnap.org/files/form_list_lookup.xls

Excel consultation and form-creation is available for a fee

thanks i think thats what i need.

 

[nicholas1986]

i realise that you need to type in the exact name inorder for a correct match.
is there a way that you just type like say A... and all those starting with A will appear in the drop down manual