Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to find and return value in cell from multiple worksheets
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 | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Find and return multiple values | 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 |