No SQL. It's an Excel. Use some Excel functions.

Data Table #1 Value Sub-Region India India India City Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Attribute Total Seats Total Seats Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Total Seats Total Seats Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Japan Japan India India India India India India India North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia Japan Japan Japan Japan Date 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 Japan Japan Japan Japan Occupied Seats Total Seats Total Seats Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Data Table #2 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 | Sub-Region India City Gurgaon Gurgaon 110 India 150 Japan North East Asia North East Asia South East Asia South East Asia South East Asia South East Asia Attribute Seated Employee Seated TVCI Seated Employee Seated TVCI Seated Employee Seated TVCI Seated Employee Seated TVCI Phillippines Phillippines Singapore Singapore 290 150 1) Please change Date format in Data Table #1 and #2 to MMM-YY (e.g Mar-15) 2) Please assign name for ranges (ie. C4:C33 as City) of Sub-Region, City and Attribute in Data Table #1 and Data Table #2 **** Please use NAMED RANGES created in question #2 to answer the below questions (if applicable) **** 3) Please apply formulas to look up the corresponding values from Data Table #1 (assuming order of row items in data table will change over time) Sub-Region City Attribute Sep-15 India India Gurgaon Gurgaon Japan North East Asia North East Asia South East Asia South East Asia Total Seats Occupied Seats Total Seats Occupied Seats Total Seats Occupied Seats Japan Singapore Singapore Data Table #1 Value Sub-Region India India India City Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Gurgaon Attribute Total Seats Total Seats Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Total Seats Total Seats Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Japan Japan India India India India India India India North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia North East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia South East Asia Japan Japan Japan Japan Date 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 Japan Japan Japan Japan Occupied Seats Total Seats Total Seats Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Singapore Total Seats Total Seats Total Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Occupied Seats Data Table #2 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 | Sub-Region India City Gurgaon Gurgaon 110 India 150 Japan North East Asia North East Asia South East Asia South East Asia South East Asia South East Asia Attribute Seated Employee Seated TVCI Seated Employee Seated TVCI Seated Employee Seated TVCI Seated Employee Seated TVCI Phillippines Phillippines Singapore Singapore 290 150 1) Please change Date format in Data Table #1 and #2 to MMM-YY (e.g Mar-15) 2) Please assign name for ranges (ie. C4:C33 as City) of Sub-Region, City and Attribute in Data Table #1 and Data Table #2 **** Please use NAMED RANGES created in question #2 to answer the below questions (if applicable) **** 3) Please apply formulas to look up the corresponding values from Data Table #1 (assuming order of row items in data table will change over time) Sub-Region City Attribute Sep-15 India India Gurgaon Gurgaon Japan North East Asia North East Asia South East Asia South East Asia Total Seats Occupied Seats Total Seats Occupied Seats Total Seats Occupied Seats Japan Singapore Singapore