Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Match and Error Handling The table on the CityData worksheet contains demographic information about several large US cities. Complete the tasks to use the drop-down

image text in transcribed
image text in transcribed
image text in transcribed
Match and Error Handling The table on the CityData worksheet contains demographic information about several large US cities. Complete the tasks to use the drop-down features in the worksheet to allow the user to specify a city and which statistics they would like to display for that city. The drop-down list in cell K 4 allows the user to select the city. The lists in cells K5 and K6 allow the user to select statistics to display for the city in cell K4. (2.1) In cell (L5) return the statistic that correspond to the city and statistics chosen by the user in cells (K4) and (K5). a. Your formula should use a combination of the VLOOKUP and MATCH functions. b. You should also employ error handling using the IFNA function in case the lookup returns invalid data. c. Note: if you use relative and absolute references appropriately, you can reuse your formula to complete the next task. city and statistics chosen by the user in cells (K4) and (K5). a. Your formula should use a combination of the VLOOKUP and MATCH functions. b. You should also employ error handling using the IFNA function in case the lookup returns invalid data. c. Note: if you use relative and absolute references appropriately, you can reuse your formula to complete the next task. (2.2) In cell (L6) return the statistic that correspond to the city and statistics chosen by the user in cells (K4) and (K6). a. Your formula should use a combination of the VLOOKUP and MATCH functions. b. You should also employ error handling using the IFNA function in case the lookup returns invalid data. Project Work Days \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ City } & Population Costoftivingindex Burgleries & MedianHouseValue MedianRent Parks \\ \hline Boston & 672840 & 145.6 & 1837 & 495400 & 1491 & 217 \\ \hline Chicago & 2704965 & 107.2 & 14258 & 243900 & 1034 & 46 \\ \hline Dallas & 1317942 & 94.1 & 10948 & 157100 & 935 & 55 \\ \hline Denver & 693060 & 112.2 & 4675 & 360900 & 1223 & 61 \\ \hline LA & 3976324 & 142 & 15821 & 593500 & 1315 & 444 \\ \hline Miami & 453584 & 115.3 & 2643 & 277700 & 1063 & 29 \\ Phoenix & 1615041 & 93.7 & 13024 & 213300 & 960 & 74 \\ \hline Seattle & 704358 & 121.6 & 7666 & 606200 & 1448 & 90 \\ \hline \end{tabular} \begin{tabular}{|cc|} \hline \multicolumn{3}{|c|}{ Drop Down Lists Statistic } \\ \hline City & Boston \\ Stat 1 & Population \\ Stat 2 & CostOfLivinginde \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Access Patterns Database Interactions In Object Oriented Applications

Authors: Clifton Nock

1st Edition

0321555627, 978-0321555625

More Books

Students also viewed these Databases questions