How do I use a formula on wk sheet 2 to pull data from wk sheet 1

  • Thread starter Thread starter WFG3000
  • Start date Start date
W

WFG3000

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 said:
How would I use a formula on work sheet 2 to automatically pull data from
worksheet 1 if a word in column 5 is ..............?
Click to expand...

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

---
 

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

lookup or match? 5
Formula in 07 7
multiple wk sheets - running balance 4
Grabbing data between worksheets 4
Linked Cells, Increment Sheet Number Ref. 3
Date plus month, year, or years in workdays 5
Match a value to multple criteria both in rows and columns 3
Pull value from another sheet 3

Back
Top