| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists and vlookup? or Match?
You're welcome!
Biff "DarnTootn" wrote in message ... thank you biff... I got it working... I had to make a couple of adjustments with the code cuz I need it to run down 150 instead of just the 78 that were shown... those were old employees that were termiated ,,, anyway thank you so so much "Biff" wrote: Merged cells are nothing but *TROUBLE* !!!!!!!!!!!!!!!!! This should have been a very simple thing to do but the merged cells required a different approach. I had to use a helper column on the Employees sheet, column J. I changed the formulas for the hourly rates to something less "complex" (and much shorter!): =IF(A17="",0,VLOOKUP(A17,Employees!A$3:E$78,4,0)) Here's your file: http://download.yousendit.com/C912583833031EA3 Remember, merged cells are a cancer! Biff "Biff" wrote in message ... Argh! Merged cells! Argh! Let me see what I can do. It may be a while. I'm getting ready for a dinner break. Biff "DarnTootn" wrote in message ... I posted here javascript:ol('http://download.yousendit.com/A3DC28565957C69A'); "Biff" wrote: Post the *EXACT* formula that you're using. Biff "DarnTootn" wrote in message ... Opps... Biff I thought it was going to work.... but after the second line it gives me a #NUM error and it is not pulling up the right name with the four digit crew number... It brings up a name but from someone elses crew "Biff" wrote: Here's a small sample file that demonstrates this: List_names.xls 15kb http://s65.yousendit.com/d.aspx?id=3...W0G3N0SXXWLA2T Sheet2 has the employee list. For your situation you'd need to copy the formula in A17 down 23 rows to cover the max number of employees in any one crew. The formula can be shortened slightly but in an effort to make things as easy to understand as possible I left some sheet references in that could be removed. Biff "DarnTootn" wrote in message ... yes I do have a table with that info.. and no on the same size... I will have anywhere from 3-23 "Biff" wrote: Hi! Does each crew have the same number of people assigned? Do you have a table that lists the employees and their respective crew number? Biff "DarnTootn" wrote in message ... I have already have my lists created.... Problem... in Cells A17:A62 I need the list of employees names to display down the column by selecting the number value in Cell A13...(A13 being a four digit crew code)... Each employee has a four digit crew number associated with them.... so far I have Cell G10 as a drop down list to select the crew name, which puts the crew four digit number in A13. So now I need Cells A17:A62 to display the employee names down the column by using the value in A13... does that make sense?? PLEASE NEED HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation and Drop down lists. | Excel Worksheet Functions | |||
| Vlookup from lists | Excel Discussion (Misc queries) | |||
| Vlookup - Comparing two lists in different worksheets | Excel Worksheet Functions | |||
| Comparing two lists in excel that don't match exactly | Excel Worksheet Functions | |||
| Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions | |||
Hybrid Mode
