Looking for some assistance with formulas. I am looking to have excel take my proposed reinforcement area (Cell H26) - locate it in the bottom table (Array C47:H58), and display what Imperial Bar it is (Column C47:C58) and Spacing (Row E46:H46). I have tried IF and MATCH. Maybe I missed something but I cant come up with a good solution.. Just trying to make a more dynamic sheet.
