GoKu
Board Regular
- Joined
- Dec 18, 2007
- Messages
- 244
Good day all. I have a Sheet(Data) with the info of learners as shown below. Then in Sheet(Ticket) I use vlookups to make the learner's ticket. I would like to know how I can make the learner's photo apear on the designated area(A2) of the ticket. I have created a Sheet(Photos) and added the learner's photos. Where the learner's Ind no is for instance Z0718728, i have named Ranged his photo as "ph Z0718728" and placed in G1. Can anyone please help me with this??
Excel Workbook | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | License No: | Date Tested: | Days left: | Surname: | Initials: | Pf Number: | Shaft: | Section: | Battery Loco: | Diesel Loco: | Flame Proof Loco: | Contracting Company: | Year Trained: | Loco Key No: | Restrictions: | Novice or Refresh: | Flag!!!: | Photo Available? | ||
2 | 748 | 17-May-10 | 549 | Thelisi | PL | Z0718728 | North | 3T | 6 | * | * | * | 2010 | * | No Restrictions | Novice | * | Yes | ||
Sheet1 |
Excel Workbook | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Beatrix Gold Mine - Loco License | * | MTETO KALO DRIVER NALO MAKALANYAN | ||||||||||
2 | * | License No: | Battery Loco: | 6 | * | 1 | Setsa Lo Ma Lamp Kalo Makalanyan | * | * | * | |||
3 | 748 | Diesel Loco: | * | * | 2 | Valo lo Masprag zonke skat | * | * | * | ||||
4 | Flame Proof Loco: | * | * | 3 | Pasopa Lo Munto Nalo Sivalo Kalo Moya | * | * | * | |||||
5 | Surname: | Thelisi | PL | * | 4 | Mamela lo Mpempe Kalo Guard | * | * | * | ||||
6 | Shaft: | North | Section: | 3T | * | 5 | Aikona Jaga lo Makalanyan | ||||||
7 | Key No: | Date Tested: | Renewal Date: | * | This loco driver is trained in the handling, transport | ||||||||
8 | * | 17-May-10 | 18-Nov-11 | * | and delivery of explosives. | * | * | * | * | ||||
9 | Pf Number: | Signature of Engineer: | * | * | * | * | * | * | * | ||||
10 | Z0718728 | * | Signature of Employee: | ||||||||||
11 | * | Restrictions: | No Restrictions | ||||||||||
12 | * | Year Trained: | 2010 | ||||||||||
Ticket |
Excel Workbook | |||
---|---|---|---|
G | |||
1 | * | ||
2 | |||
3 | |||
4 | |||
5 | |||
6 | Z0718728 | ||
Photos |