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

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