Problem
Mom needs your help. She needs to send out invitations to everyone for the 60th High school Reunion. Mom has a main Excel table (master list) which includes the columns: First, Maiden, Last, Address, City, etc. She has created an additional table to keep track of the newly deceased. Now Mom needs to update the main table to include the currently deceased. Unfortunately, mom canât check out all 400 hundred individuals.
Use whatever you have learned thus far in this class (text functions, logic functions, vlookups, etc). In order to update the status of all 400 hundred individuals at one time. Remember, there may be additional spaces lurking around. The master list has also added nick names and abbreviated middle names in the First name column (those have to be removed).
You have to make the table work in such a way that when Mom adds a new name to the currently deceased table, the main table is updated automatically. You may assume that when a first name is entered in the deceased list, only one word is entered. For example, while âMary Louâ may be entered in the master list first name, only Mary is put in the deceased list first name. You may use as many intermediate columns for calculations, as long as column I updates correctly for all possible cases.