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