I am working on a project that utilizes client and vendor data. Basically, once a client's contract is awarded to the vendor, I can enter a key (a 3 letter acronym of the vendor name) on the client sheet, that matches with a row of values describing the vendor. This key in turn populates the next 8 or so fields of the client sheet with data (mailing block, etc) pulled from the vendor sheet.
Currently, I am using
lookup function on the client sheet (where AQ2 = vendor key, entered on
Client!) with this formula (in different flavors):
=LOOKUP(AQ2, Vendor!A:A, Vendor!H:H)
This works, for one vendor; so I can send off the contract award letter and stuff like that to the one winner. However, is there is a way to send letters to all the people who don't win the contract?
So say 4 vendors bid, 3 need "decline" letters; but the 3 sets of information need to be managed from 1 sheet whose keys are Client! based just like the "award";
- How do I use
lookupor another analogous function to import the information for a mail merge for multiple recipients based on a client key spreadsheet (Is it possible?) ? (This would be in addition to the initial 'award' lookup; thought not necessary at the same time.)