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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone