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
|