Creating place cards with food icons for weddings

KT50

New Member
Joined
Oct 29, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have created an excel spreadsheet to do a data merge with InDesign. All works just fine. Can add an image (icon of beef, fish or chicken) by inserting @Image column and copying path to the icon. However, I would like to take it a step further. The client sends me the spreadsheet with columns filled with guest names, food choices etc. I am trying to work out how to link the food words to the food images. ie if she has noted beef, it will automatically link with the beef icon image. I just cannot work it out. I am ok with this stuff but not a tech-head so simple is best for me! Thanks in advance!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,118,355
Messages
5,571,693
Members
412,413
Latest member
dvprajapati
Top