bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
Hey Guys n Girls I am trying to automate a data spreadsheet with the above functions.
What I have is spreadsheet to record Higher Duties and Column A is Payroll Number Column B is the staff name via a drop down box and Column C is their current pay increment so I have started on a formula =IF(AND(B3=Data!B2:B128),LOOKLEFT,Data!A2:A128) that is in Higher Duties A3 and what I am trying to achieve is a pick from the drop down box a staff name "Bob" in Data B3 it then looks in the DATA sheet B2:B128 finds "Bob" and looks left and enters his payroll number in Higher Duties A3
Also same as above "Bob" is in B3 and =IF(AND(B3=Data!B2:B128),LOOKLRIGHT,Data!C2:C128) and the formula would look through C2:C128 find Bob,s increment and that would appear in Higher Duties C3.
looking at this it looks messy and I hope I have explained well enough
Many thanks in advance
Cheers from Oz
What I have is spreadsheet to record Higher Duties and Column A is Payroll Number Column B is the staff name via a drop down box and Column C is their current pay increment so I have started on a formula =IF(AND(B3=Data!B2:B128),LOOKLEFT,Data!A2:A128) that is in Higher Duties A3 and what I am trying to achieve is a pick from the drop down box a staff name "Bob" in Data B3 it then looks in the DATA sheet B2:B128 finds "Bob" and looks left and enters his payroll number in Higher Duties A3
Also same as above "Bob" is in B3 and =IF(AND(B3=Data!B2:B128),LOOKLRIGHT,Data!C2:C128) and the formula would look through C2:C128 find Bob,s increment and that would appear in Higher Duties C3.
looking at this it looks messy and I hope I have explained well enough
Many thanks in advance
Cheers from Oz