AUTOMATIC INFILL FROM LIST

[KINGHOUSE43]

I am trying to set up an overtime form to automatically input the details and all i have to do is input the hrs worked and have excel calculate the overtime payment.

I have a list of grades which have 4 different payrates depending on the date worked. I have a list of names and grades, I would like the relevant name, grade and pay rates to be automatically entered when I input the payroll no, I already have formulas set up to calculate the the hours worked etc. or If I type in relevant grade (13 off), then the hrly rate, weekday rate,Saturday Rate and Sunday rate are populated automatically.

e.g. payroll no: Name: Grade: hrly rate: weekday rate: Saturday Rate: Sunday Rate:

I hope you can help

Ta Much

 

[PaddyD]

Hi - welcome to the board!

This should be fairly straightforward - in general the "return a set of values from a list / table of values that match another item from the list" is solved by vlookup() or similar functions. Check it out in the help / search this board for examples.

Post back with more details about how your data is set up if you want more help on this...

Paddy