LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default HLookUp combined with a VLoopkUp...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup and hlookup hotelmasters Excel Worksheet Functions 4 August 15th 06 08:41 PM
combined HLOOKUP (urgent for a friend) tom ossieur Excel Worksheet Functions 6 August 9th 06 03:56 PM
Problem with HLookup - Sometimes works, sometimes blank. Regnab Excel Discussion (Misc queries) 3 May 22nd 06 04:09 AM
Index / Hlookup Pamela Creighton Excel Worksheet Functions 1 February 5th 06 07:22 PM
Need help with HLOOKUP and MATCH functions BEAR94 Excel Worksheet Functions 1 August 12th 05 05:36 AM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"