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

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data 1
Validate Sku No in Sheet 1 against Sheet 2 7
Pull Information from one sheet to another 1
Copy Data from One sheet to Different Sheets 1
Formula to pull data from one sheet to another if X = Yellow 3
To Make a Changing Data Sheet 4
Excel, assign cells in multiple worksheets from one sheet 1
Line Item 2

Top