User Profile
JakeTWalker97
Copper Contributor
Joined Nov 10, 2021
User Widgets
Recent Discussions
Returning text value if two cells match
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. 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. I have tried using index match and xlookup to no avail. Any help would be greatly appreciated. Thank you!Summing value based on common ID between two different sheets
Hi all, I am trying to sum a certain value based on certain criteria between different sheets. In the below picture, I would like to sum the Total GLA based on the Asset Manager. The Asset Managers are stored on a separate sheet as seen below. The GLA is again stored on another separate sheet as seen below. Normally, to complete such a function I would use the SUMIFS formula. However, due to location on different sheets, this does not work. Additionally, there is the added difficulty that the common denominator between the sheets is the property ID and not the asset manager, as the asset manager is not listed on the same sheet with the GLA. In PowerBI, I could use a relationship functionality but I am trying to stay away from Pivot Tables or Power Pivot. What would be the best way to accomplish this? Much appreciation to any help!
