Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup employee name and return data from multiple rows
Hi,
I need help creating a formula to lookup one employee's name and display their weekly net pay. I need the formula on the transactions worksheet to search for one employee's name in the source info worksheet and return the data in a cell associated with their name, and return that to the transactions worksheet. They have reoccuring weekly transactions and I need each weeek displayed seperatly on the transactions worksheet Example: I need the transaction worksheet to serach for Bob Somone in Column C of the source worksheet, and return the value that is associated with Bob Somone from Column J of the source worksheet. And I need that to be done for each week. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup employee name and return data from multiple rows
Joe;223004 Wrote: Hi, I need help creating a formula to lookup one employee's name and display their weekly net pay. I need the formula on the transactions worksheet to search for one employee's name in the source info worksheet and return the data in a cell associated with their name, and return that to the transactions worksheet. They have reoccuring weekly transactions and I need each weeek displayed seperatly on the transactions worksheet Example: I need the transaction worksheet to serach for Bob Somone in Column C of the source worksheet, and return the value that is associated with Bob Somone from Column J of the source worksheet. And I need that to be done for each week. Any ideas? Might a Pivot Table be what you want.? Just group the dates by week -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Lookup to return multiple data from the same column | Excel Discussion (Misc queries) | |||
Lookup and return value 12 rows below | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |