Auto enter info in a cell

I have criteria for kits which comprise a number of components. Is there a way to enter information in a number of cells (the components) automatically after entering a value in the first cell (the kit reference)?

Hi,

Yes with the vlookup() function ...

=vlookup(kitreference,alldatabase,columNumber)


HTH
Carim