| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull data from multiple sheet | Excel Worksheet Functions | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
| If Info. from one Sheet matches, send it to another sheet | Excel Discussion (Misc queries) | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Linear Mode
