Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The the Guru's:
What I need is to create a cross section using a sort of HLookUp and VLookUp function. HLookUp to find a Employee name on a specific row in column "A", then use the VLookUp to pick up specific data for the employee four (5) rows columns F - Q down at the intersection point! Is that possible? If it is, how can I get it done? Column "A1:A45" has Employee names every 5th row starting at row A5. Now across heading of columns "F" through "Q" are month of year names. What I need is to select a employee name on row "A5" and have all the data for that employee show up for column "M5, M6, M7, M8 and M9" = August data for this employee. If I select an employee name in row A15, I want to see the data for this employee listed in column N15, N16, N17, N18,N19 = September data for this employee. See sample data below, I hope it fits: A J K L M N May June Jul Aug Sept Oct Javier Garza 21900.00 Income Tax / Loon Belaasting AOV / AWW = Employee(4%) 0.00 0.00 876.00 AZV = Employee (1.6%) 0.00 0.00 350.40 Totals Juan Mattos 1250.00 1350.00 1400.00 1400.00 Income Tax / Loon Belaasting AOV / AWW = Employee(4%) 50.00 54.00 56.00 56.00 AZV = Employee (1.6%) 20.00 21.60 22.40 22.40 Totals If there are questions, please, post back! Thanks,... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup and hlookup | Excel Worksheet Functions | |||
combined HLOOKUP (urgent for a friend) | Excel Worksheet Functions | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Index / Hlookup | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions |