How would I use a formula on work sheet 2 to automatically pull data from
worksheet 1 if a word in column 5 is ..............?

"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
---