I have a Table1 with columns

• [@First]
• [@Last]
• [@Age]
• [@Partner]
• [@Partner_Age]
• [@People] computed as =MID([@First],1,1)&"."&[@Last]

I am trying figure out a formula for the Partners age. Something like:

INDIRECT(ADDRESS(...row of partner..., ...@AGE column...))

First,Last,Age,Partner,Partner_Age,People
A,P,30,C.R
B,Q,35,D.S
C,R,32,A.P
D,S,33,B.Q

My first step of the formula is failing to get the row of the partner,

=MATCH([@Partner],[@People]) is always #N/A