| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search worksheets in same book to return value matching criteria? | Excel Worksheet Functions | |||
| Search for multiple criteria, and return yet another | Excel Worksheet Functions | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| Search multiple values & return single value - seperate worksheets | Excel Worksheet Functions | |||
| search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions | |||
![Jane Doe[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
