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
 

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 background color from master to other sheet 2
Copy entire row from another sheet onto first sheet if a unique text matches 1
Copy Data from One sheet to Different Sheets 1
How do I only pull rows if the data matches a named range? 0
External cell reference between two excel worksheets both in One Drive 0
Pull Information from one sheet to another 1
Pulling data 1
Validate Sku No in Sheet 1 against Sheet 2 7

Top