Search multiple worksheets and return value based on phone number

J

Jane Doe

Need to find value in column P of multiple worksheets (i.e. may_acct1,
may_acct2, may_acct3) based on phone number in column A of these worksheets
matching phone number in column F of main worksheet and return that value
from column P to column B,C, or D based on worksheet month (may_acct1,
june_acct1 or may_acct2, june_acct2).

Worksheet format to search

column
A.........................................................................columnP
Subscriber
Number...........................................................Subscriber
Total



Worksheet format to return results

column A...(column B, C and D)..................column
E...................column F
Subscriber Total
Name May June July Active Carrier
Subscriber Number
 

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

Search multiple worksheets and return value to main worksheet 7
Need to find and return value in cell from multiple worksheets 0
Finding and returning value from multiple worksheets 1
search worksheets in same book to return value matching criteria? 3
Excel VBA macro, search - accumulate - delete original 0
Help with lots of formulas 3
Compare 2 lists and return value 1
matching & combining data from seperate worksheets 2

Top