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.