Can_This_Be_Don
Board Regular
- Joined
- Feb 15, 2005
- Messages
- 88
Not sure how to set up this vlookup so am seeking advice. In cell G1 a code will be entered. I then need to look in the table (cells A1:C8) if it is found, to look at the day and carry the corresponding time to column H against the appropriate day.
To give you a better understanding G1 shows LSA03, in the table it finds the matching record, to the left it then finds the day, then the value in C4 is shown in H4.
The data I'm showung is only an example but I'm struggling to get the vlookup to work correctly.
To give you a better understanding G1 shows LSA03, in the table it finds the matching record, to the left it then finds the day, then the value in C4 is shown in H4.
The data I'm showung is only an example but I'm struggling to get the vlookup to work correctly.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Day | Duty | Start | Duty | LSA03 | |||||
2 | Mon | LSA01 | 09:00 | Mon | ||||||
3 | Tue | LSA02 | 10:45 | Tue | ||||||
4 | Wed | LSA03 | 12:30 | Wed | 12:30 | |||||
5 | Thu | LSA04 | 14:15 | Thu | ||||||
6 | Fri | LSA05 | 16:00 | Fri | ||||||
7 | Sat | LSA08 | 17:45 | Sat | ||||||
8 | Sun | LSA9 | 19:30 | Sun | ||||||
Sheet1 |