Search multiple worksheets and return value based on phone number
 

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

Search multiple worksheets and return value based on phone number
 

Hi,

Your question is not clear. May I request you to mail me the question at


--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jane Doe" wrote in message
...
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