There is an even more flexible version of INDEX/MATCH called INDEX/MATCH/MATCH that will allow you to even lookup the column.
finance
Description
| There is an even more flexible version of INDEX/MATCH called INDEX/MATCH/MATCH that will allow you to even lookup the column. | |||||||||
| Below is a simple "dashboard" that allows you to select two census tracts as well as a variable. It then graphs them below to show you the comparison. | |||||||||
| Click on the cells with the tract IDs or the header below to see that you can use a drop-down menu to | |||||||||
| Feel free to research the INDEX function in the Excel help or look for help on INDEX/MATCH/MATCH on the internet. | |||||||||
| % Male; Population | |||||||||
| 1400000US53053072901 | |||||||||
| 1400000US53075000100 | |||||||||
