Spreadsheet: 39954d1238183253-double-lookup-intersect-formulas-and-example-table
Sheet: Intersection Formulas

 | Month | January | February | March | April | May | June | July | August | September | October | November | December
 | A | 356 | 386 | 405 | 100 | 503 | 791 | 109 | 227 | 862 | 515 | 833 | 224
 | B | 251 | 472 | 3 | 889 | 571 | 141 | 927 | 356 | 108 | 859 | 534 | 443
 | C | 534 | 490 | 470 | 409 | 667 | 253 | 899 | 579 | 764 | 137 | 124 | 807
 | D | 53 | 282 | 31 | 592 | 741 | 509 | 7 | 978 | 740 | 184 | 509 | 538
 | E | 149 | 816 | 220 | 773 | 134 | 91 | 27 | 717 | 897 | 719 | 952 | 140
 | F | 952 | 937 | 356 | 570 | 956 | 276 | 579 | 689 | 705 | 382 | 101 | 410
 | G | 234 | 304 | 754 | 720 | 885 | 34 | 61 | 185 | 286 | 792 | 196 | 703
 | H | 768 | 899 | 552 | 992 | 450 | 782 | 254 | 30 | 151 | 575 | 285 | 845
 | I | 947 | 757 | 75 | 103 | 824 | 14 | 243 | 951 | 759 | 325 | 620 | 206
 | J | 394 | 121 | 897 | 797 | 433 | 713 | 316 | 779 | 261 | 698 | 32 | 512
 | K | 584 | 596 | 942 | 569 | 670 | 661 | 57 | 115 | 205 | 335 | 373 | 611
 | L | 959 | 375 | 786 | 424 | 62 | 525 | 647 | 432 | 23 | 275 | 41 | 648
 | M | 863 | 170 | 771 | 290 | 233 | 88 | 287 | 717 | 556 | 500 | 898 | 734
 | N | 6 | 551 | 764 | 274 | 337 | 712 | 91 | 96 | 175 | 63 | 523 | 10
 | O | 891 | 49 | 553 | 189 | 942 | 607 | 919 | 562 | 683 | 748 | 647 | 111
 | P | 994 | 495 | 796 | 671 | 764 | 833 | 621 | 936 | 127 | 232 | 339 | 197
 | Q | 415 | 6 | 379 | 502 | 658 | 653 | 183 | 679 | 54 | 525 | 790 | 598
 | R | 244 | 646 | 163 | 857 | 646 | 643 | 926 | 329 | 205 | 875 | 798 | 329
 | S | 145 | 838 | 815 | 267 | 515 | 777 | 790 | 752 | 637 | 393 | 459 | 640
 | T | 451 | 432 | 60 | 546 | 920 | 7 | 813 | 344 | 889 | 808 | 307 | 703
 | U | 755 | 255 | 377 | 290 | 198 | 802 | 770 | 835 | 419 | 468 | 247 | 231
 | V | 668 | 757 | 456 | 617 | 867 | 305 | 874 | 908 | 594 | 4 | 11 | 11
 | W | 76 | 719 | 527 | 418 | 525 | 366 | 429 | 822 | 597 | 956 | 787 | 919
 | X | 276 | 130 | 772 | 714 | 641 | 71 | 939 | 225 | 819 | 379 | 20 | 887
 | Y | 334 | 102 | 225 | 276 | 779 | 468 | 300 | 436 | 161 | 757 | 511 | 398
 | Z | 875 | 354 | 142 | 553 | 78 | 203 | 463 | 798 | 284 | 1000 | 538 | 513
 | July |  |  |  |  |  | Q
 |  |  |  |  |  |  |  |  |  |  |  |  | Indirect | Index
 | To easily create named ranges select your entire table (in this example it's B2 to N28)
 | go to [NAME]>Defined Names>Create from Selection
 | [NAME] and [NAME] if not already selected
 | In this example I used A thru Z, excel already had C and R defined (Column and Row) so it adds a underscore "_" to the named range so the indirect formula will throw a #[NAME] error if used with out updating the row headers
 | After you have your rows and columns defined the intersect formula is simple.
 | create a validation list from your rows and columns (example is H29 and [NAME] (merged together with other columns for better visual effect))
 | After you have your validation lists the formula is a space " ".  But to use the list as your data you need to use the indirect function which will make the text back to the range
 | formula is =INDIRECT(B29) INDIRECT(H29)
 | the more common approach is the index/match formula which I have also added to O29
 | formula is =INDEX(Month,MATCH(H29,data2,0),MATCH(B29,data,0))
 | Which is pretty cool as well
 | Conditional formulas are for visual aid which I like as well
 | to highlight the rows
 | formula is =$B3=$H$29
 | to highlight the columns
 | formula is =C$2=$B$29
 | to highlight the cell
 | formula is =AND(C$2=$B$29,$B3=$H$29)
 | note: fromula to highlight the cell must be first condition or the others will overwrite