VoterID 100100 100200 100300 100400 100500 100600 100700 100800 100900 101000 101100 101200 101300 101400 101500 101600 101700 101800 101900 102000

How would you do multiple vlookups such as: Adding a column to the Voting History sheet to report the Election Type Category (e.g., “Primary” or “General”) for each voting record in the Voting History. (Hint: start with data on the Voting History sheet and determine what “path” gets you from there to the values of “Primary” or “General” – you may have to go through multiple sheets/data tables – how can you connect them?)