Excel Advanced Autofill

  Scott_the_Scot 12:45 03 Feb 2008
Locked

I am trying to find a way of autofilling information in excel. Let me try and explain what I am trying to do. I have a large list of items in excel with information relating to each one. When I type in the name of the item excel can fill in the name of the item from just a few letters. Is it possible to make it also bring the associated information for this item.

  VoG II 14:28 03 Feb 2008

Take a look at VLOOKUP - there is a tutorial click here under 'Advanced Excel Functions'.

  Scott_the_Scot 12:26 09 Feb 2008

Thanks VoG this helped sort out the problem.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?