Returning text value if two cells match

%3CLINGO-SUB%20id%3D%22lingo-sub-3067582%22%20slang%3D%22en-US%22%3EReturning%20text%20value%20if%20two%20cells%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3067582%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20match%20text%20contained%20within%20one%20cell%20to%20an%20array%20that%20contains%20a%20bunch%20of%20text%20to%20return%20another%20text%20value%20based%20on%20which%20column%20it%20was%20in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20tenants%20that%20populates%20based%20on%20their%20outstanding%20rent%20from%20high%20to%20low.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JakeTWalker97_0-1642713114053.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341128i581DB599CDC1052D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JakeTWalker97_0-1642713114053.png%22%20alt%3D%22JakeTWalker97_0-1642713114053.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20this%2C%20I%20want%20to%20match%20the%20tenant%20to%20which%20property%20they%20are%20located%20at.%20I%20have%20a%20data%20set%20located%20on%20another%20tab%20that%20contains%20this%20data.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JakeTWalker97_1-1642713217654.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341129i0C447363B67A8D4D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JakeTWalker97_1-1642713217654.png%22%20alt%3D%22JakeTWalker97_1-1642713217654.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20using%20index%20match%20and%20xlookup%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3067582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

 

I am looking to match text contained within one cell to an array that contains a bunch of text to return another text value based on which column it was in.

 

I have a list of tenants that populates based on their outstanding rent from high to low.

JakeTWalker97_0-1642713114053.png

 

Based on this, I want to match the tenant to which property they are located at. I have a data set located on another tab that contains this data.

JakeTWalker97_1-1642713217654.png

 

I have tried using index match and xlookup to no avail.

 

Any help would be greatly appreciated. Thank you!

 

 

1 Reply

@JakeTWalker97 

=INDEX(C$13:C$18,MATCH($C3,$B$13:$B$18,0))

 

Maybe with this formula as in the attached file.