Lookup with dynamic Row and Column

stilwellj1983

New member
Joined
Sep 23, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Office 365
I have a document that I would like to lookup the far left column but both my row and column are floating. see example below. In the formula I would know 1 - 6 and the name, I want to return the A - F.


123456
ASteveJohnJoeMikeGrayHanna
BJohnJoeMikeGrayHannaSteve
CJoeMikeGrayHannaSteveJohn
DMikeGrayHannaSteveJohnJoe
EGrayHannaSteveJohnJoeMike
FHannaSteveJohnJoeMikeGray
 
I am not understanding your needs. Please explain in simple terms what you are trying to do. Provide an example in your step by step narrative with your expected results. Your current request is to vague to determine your requirements.
 
Back
Top