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

J

JerriH

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
 
J

JerriH

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.
 
G

Gord Dibben

Jerri

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


Gord Dibben MS Excel MVP
 
Top