excel info

  moorie 17:20 02 May 2006
Locked

hi novice excell user here,is it possible to search in a specific column in a spreadsheet.
the spreadsheet contains product codes and discriptions as well as cost price in seperate columns basically i want to search for a product code to quickly match up the cost price?
regs Daarren

  VoG II 17:25 02 May 2006

Select the column first by clicking the grey column heading. Then Edit > Find.

  johnnyrocker 17:30 02 May 2006

the look up function should help


johnny.

  johnnyrocker 17:32 02 May 2006

click here


johnny.

  VoG II 17:35 02 May 2006

Ah, you mean you want a formula to search?

johnnyrocker is correct -

VLOOKUP(value, datarange, data column number in the range, FALSE)

Product code has to be to the left of price for this to work. Otherwise you'll need a combination of INDEX and MATCH.

  moorie 17:44 02 May 2006

thanks guys works a treat
Darren

  Noldi 18:40 02 May 2006

Select The Coloumn Range

Then

Data - Filter - Auto Filter

Noldi

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

Elsewhere on IDG sites

Samsung Galaxy S9 review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?