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 | |||
