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 VLookUp or HLookUp Plus Index - Match, I think???

This one requires the Excel guru's or any one with an answer!

What I need to do is the following. I have part of it working already, but,
still miss additional information.

I have an application which contains data for employees names on a sheet
called "EmpData". The data is listed as column and cell A2 - Employee Name,
then, by month (Jan, Feb, March, Apr, May, Jun, Jul - Dec) In the columns F -
Q where the month are listed are Jan - Dec row 5 (Gross Income), row 6 = Fed
IncomeTax, row 7 = State IncomeTax, row 8 = Social Security, row 9 = Fica.

What I want or would like to do is select the employee name from a dropdown
combo box on a sheet called "Review" pull and have the selected target cells
populated with the respective data from a sheet called "EmpData", is this
possible? I guess that Index - Match may not be enough to pull everything I
need. I also need to have any blank vertical cells between the employees
names filtered out or dropped.

Any ideas or samples spreadsheet providing a solution will be welcomed!

I hope my explanation was clear, if not, post any questions you may have...

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
Index, Match and filters Steve M Excel Discussion (Misc queries) 4 August 22nd 06 09:12 PM
VLookup or Index Match or ??? KopRed Excel Worksheet Functions 1 February 17th 06 05:34 AM
Function Vlookup, Match or Index? Patrick Young Excel Worksheet Functions 0 October 3rd 05 11:08 PM
Need help with HLOOKUP and MATCH functions BEAR94 Excel Worksheet Functions 1 August 12th 05 05:36 AM
Vlookup and Hlookup Phlogiston2312 Excel Worksheet Functions 1 April 21st 05 04:59 PM


All times are GMT +1. The time now is 10:35 PM.

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"