Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup formula for wages, add in another?
I have a sheet for all my job costing SHEET 1.
I have a sheet with my employees and wages LABOR RATES. I have set up the formula LOOKUP(B8,'Labor Rates'!A$3:D19) in sheet 1 so once I choose the employee from the dropdown box their wage matches. But my problem is when I add a new employee into my LABOR RATES and their wage, their name is added to my dropdown list in SHEET 1 and when I choose the new one the wage is incorrect? What am I missing? thanks tb |
#2
|
|||
|
|||
tb
I would suggest a dynamic LOOKUP range instead of A$3:D19 on your Labor Rates sheet so's it would accomodate newly inserted employees. Also, perhaps VLOOKUP would be better. =VLOOKUP(B8,'Labor Rates'!myrange,column,false) To set up a dynamic range(myrange), see Debra Dalgleish's site. http://www.contextures.on.ca/xlNames01.html#Dynamic Gord Dibben Excel MVP On Tue, 12 Apr 2005 14:37:59 -0700, "tb" wrote: I have a sheet for all my job costing SHEET 1. I have a sheet with my employees and wages LABOR RATES. I have set up the formula LOOKUP(B8,'Labor Rates'!A$3:D19) in sheet 1 so once I choose the employee from the dropdown box their wage matches. But my problem is when I add a new employee into my LABOR RATES and their wage, their name is added to my dropdown list in SHEET 1 and when I choose the new one the wage is incorrect? What am I missing? thanks tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question... LookUP | Excel Discussion (Misc queries) | |||
copying LOOKUP formula | Excel Worksheet Functions | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
Conversion lookup formula | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |