On Nov 11, 1:32*pm, Pete_UK wrote:
Here's the formula that you need in cell J29 of SheetA:

=INDEX(SheetB!$B$9:$BU$80,MATCH(P20,SheetB!$A$9:$A $80),MATCH(J20,$B
$8:$BU$8))

The first MATCH is locating the appropriate row, so it is finding a
match with the Spouse age in column A, and the second MATCH is
determining the column by finding a match with the Employee age in row
8.

Hope this helps.

Pete

On Nov 11, 6:07*pm, clk wrote:





Hi thank you for the reply. *I have been researching Index/Match and
just can't quite get it right. *OK....on worksheet A. *Employee Age is
located in cell J20. *Spouse Age is located in P20. *In cell J29 I
have a cell to show the number it should grab from Worksheet B.

On Worksheet B, I have going across row 8 (B8 through BU8). *This runs
from age 19 to age 90 going across the top.

Coming down column A. *Spouse's age is stored in A9 through A80.
Again this is from age 19 to age 90.

Where the two ages intersect, I need to capture that number. *So first
look across to find employee age (41). *Then go down column A to find
spouse's age (40). *The number where to columns and rows intersect is
the number I need plugged in to cell J29 on the Worksheet A.

I hope this gives you enough detail. *Please let me know if any other
information is needed. *Thanks again.- Hide quoted text -

- Show quoted text -

It worked!!! Thank you so much for your assistance. That is exactly
what I needed.