Find a specific cell by using a row and data in rows and columns

I have a spreadsheet A5 through A11 is ABCDEFG. B5 through H11 has (101,102, 103….) number data in it. B4 throughH4 is 1,2,3,4,5,6,7 I need to wirte a formula that if i enter a number 1 through 7 in a cell and in the another cell I put in some of one of the numbers (101, 102, 103,…) it will find where the two numbers intersect and display the data inB5 through B8. Example if I chose 3 and 103 those intersect in D10 so Ineed D5 to display. Screen shot below

 



               
  1 2 3 4 5 6 7
A 101 104 107 101 107 101 104
B 107 101 102 102 106 102 107
C 104 105 106 103 101 103 101
D 106 107 105 104 103 104 106
E 103 106 104 107 102 105 102
F 102 102 103 106 105 106 105
G 105 103 101 105 104 107 103
               
               
        Date (B4 through H4) 3  
               
        Data B5 through H11)  103  
               
        Display Letter where both data meets F
               

By: Paul

Leave a Reply

Your email address will not be published. Required fields are marked *