Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use a formula on wk sheet 2 to pull data from wk sheet 1
How would I use a formula on work sheet 2 to automatically pull data from
worksheet 1 if a word in column 5 is ..............? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use a formula on wk sheet 2 to pull data from wk sheet 1
"WFG3000" wrote:
How would I use a formula on work sheet 2 to automatically pull data from worksheet 1 if a word in column 5 is ..............? Index/Match would be one good way to use Eg: Assume you want to extract corresponding stuff from col C in Sheet1 where the word in col E (in Sheet1) matches with the word that is listed in Sheet2's col A (I read column 5 as == col E) In Sheet2, you could place in B2, and copy down: =INDEX(Sheet1!C:C,MATCH(A2,Sheet1!E:E,0)) The part: INDEX(Sheet1!C:C .. is what you want extracted based on matching in the part: MATCH(A2,Sheet1!E:E,0) (ie matching A2 with col E in Sheet1) And if you need an error trap to return neat looking blanks: "" for any unmatched cases, you could use this instead in B2: =IF(ISNA(MATCH(A2,Sheet1!E:E,0)),"",INDEX(Sheet1!C :C,MATCH(A2,Sheet1!E:E,0))) Adapt to suit .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to pull data from one sheet to another if X = Yellow | Excel Worksheet Functions | |||
VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |