item # in one sheet want to pull data that matches from other tab
 

I want to use an item # in one sheet to pull data from another sheet that
matches that number into a new cell.

If I have an item #72 on sheet 1 with 6 columns of data - I want to add a
7th and take new info from another cell on another sheet of that same item #.
Is there a function to do that? SMy sheets have 1800 skus ... help!

EG:

sku April Stats May Stats
ABCD 9 find and pull from another sheet

item # in one sheet want to pull data that matches from other tab
 

Have you tried VLOOKUP yet?


"JerriH" wrote:

I want to use an item # in one sheet to pull data from another sheet that
matches that number into a new cell.

If I have an item #72 on sheet 1 with 6 columns of data - I want to add a
7th and take new info from another cell on another sheet of that same item #.
Is there a function to do that? SMy sheets have 1800 skus ... help!

EG:

sku April Stats May Stats
ABCD 9 find and pull from another sheet

item # in one sheet want to pull data that matches from other
 

Yes - but the formula doesn't seem to work - it pulls a 1, 0 etc... but not
the actual data from the cell on the other sheet.

"AKphidelt" wrote:

Have you tried VLOOKUP yet?


"JerriH" wrote:

I want to use an item # in one sheet to pull data from another sheet that
matches that number into a new cell.

If I have an item #72 on sheet 1 with 6 columns of data - I want to add a
7th and take new info from another cell on another sheet of that same item #.
Is there a function to do that? SMy sheets have 1800 skus ... help!

EG:

sku April Stats May Stats
ABCD 9 find and pull from another sheet

item # in one sheet want to pull data that matches from other
 

Jerri

Post your formula and the table range on the other worksheet.


Gord Dibben MS Excel MVP

On Mon, 21 May 2007 08:52:01 -0700, JerriH
wrote:


Yes - but the formula doesn't seem to work - it pulls a 1, 0 etc... but not
the actual data from the cell on the other sheet.

"AKphidelt" wrote:

Have you tried VLOOKUP yet?


"JerriH" wrote:

I want to use an item # in one sheet to pull data from another sheet that
matches that number into a new cell.

If I have an item #72 on sheet 1 with 6 columns of data - I want to add a
7th and take new info from another cell on another sheet of that same item #.
Is there a function to do that? SMy sheets have 1800 skus ... help!

EG:

sku April Stats May Stats
ABCD 9 find and pull from another sheet