Hi,
So I am having some trouble figuring out how to summarize the square feet of the fences being applied to concrete, grass. asphalt and soil.
What I am looking to achieve is for excel to look for "*concrete*" in rows B4:AE6, and return the values in row 7 (the height). In this case that would be 44 and 40.
I have tried using hlookup but it only returns on value but I need it to look for all the match part of the text.
Help please
So I am having some trouble figuring out how to summarize the square feet of the fences being applied to concrete, grass. asphalt and soil.
What I am looking to achieve is for excel to look for "*concrete*" in rows B4:AE6, and return the values in row 7 (the height). In this case that would be 44 and 40.
I have tried using hlookup but it only returns on value but I need it to look for all the match part of the text.
Help please