Thanks for the help on that, I have one more question before everything is done. I want to use a similar formula to figure out what their personal counts are for the projections in row 21. Now that the last formula allowed me to gather information from the "footprints" tab, I need a formula that would go to the "personal counts" tab and look at 13watt bulbs, then look at the list of names in column A, and If there name is in the column A of the "dropbox" tab, then give a total result. I have tried tweaking the one you created earlier, but i cant figure out how you used multiple criteria for the drop box results.