Hello
I was wondering if you could help write a lookup to return 24864
I would like to lookup A7 and match C5 in the range AB4:AL50, hopefully this makes sence
thank you
I was wondering if you could help write a lookup to return 24864
I would like to lookup A7 and match C5 in the range AB4:AL50, hopefully this makes sence
thank you
| JAY - Labour Schedule - JWS - Live Trial 6.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 4 | WE - 24/10/2021 | Monday | |||||
| 5 | 18/10/2021 | ||||||
| 6 | Andrew Ball | 25027 | |||||
| 7 | AB | TG Beighton Joseph Ash Bilston | |||||
| 8 | 06:00 | 13:20 | 07:20 | ||||
190921 (2) | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A4 | A4 | =U5 |
| C5 | C5 | =F5-1 |
| C7 | C7 | =IFERROR(VLOOKUP(C6,Planner1!$A$10:$Q$90,17,0),"") |
| E8 | E8 | =D8-C8 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| E8 | Cell Value | =0 | text | NO |
| C27:W27,C24:W24,C21:W21,C18:W18,C15:W15,C12:W12,C6:W6,F9:W9,C30:W30,C33:W33,C36:W36,C39:W39,C42:W42,C45:W45,C48:W48,C51:W51,C54:W54,X6:Y56 | Cell Value | =0 | text | NO |
| JAY - Labour Schedule - JWS - Live Trial 6.xlsm | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | |||
| 3 | Date: | Op 1 | Op 2 | Op 3 | Op 4 | Op 5 | Op 6 | Op 7 | Project No. | Project Name: | |||
| 4 | 18-Oct | KS,AB | KS | AB | 24864 | KERRINGTON Units C&D | |||||||
| 5 | 18-Oct | CN,SB | CN | SB | 25027 | TG Beighton Joseph Ash Bilston | |||||||
| 6 | 18-Oct | 0 | 0 | 25097 | JCC COBHAM RETIREMENT VILLAGE | ||||||||
| 7 | 18-Oct | 0 | 0 | 25143 | BASTOWS Ashland House, Ashland Place, London, W1U 4AJ | ||||||||
| 8 | 18-Oct | 0 | 0 | 24899 | SANDFORDS WEST BROMWICH | ||||||||
| 9 | 18-Oct | JM,JL | JM | JL | 24070 | RAF Whattisham | |||||||
| 10 | 18-Oct | 0 | 0 | 24347 | JN BENTLEY P&G West Thurrock | ||||||||
| 11 | 18-Oct | 0 | 0 | 24629 | Culver Farm | ||||||||
| 12 | 18-Oct | 0 | 0 | 24683 | SPEC Rengen Bristol | ||||||||
190921 (2) | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AB4:AB12 | AB4 | =Planner1!$AK$6 |
| AC4:AC12 | AC4 | =Planner1!AL10 |
| AD4:AD12 | AD4 | =LEFT(AC4,2) |
| AE4:AE12 | AE4 | =MID(AC4,4,2) |
| AF4:AF12 | AF4 | =MID(AC4,7,2) |
| AG4:AG12 | AG4 | =MID(AC4,10,2) |
| AH4:AH12 | AH4 | =MID(AC4,13,2) |
| AI4:AI12 | AI4 | =MID(AC4,16,2) |
| AJ4:AJ12 | AJ4 | =MID(AC4,19,2) |
| AK4:AK12 | AK4 | =Planner1!A10 |
| AL4:AL12 | AL4 | =Planner1!Q10 |
