Home/ Questions/Q 527
In Process
computing
  • 15
Asked: 2021-09-03T20:01:53+00:00

Solved Excel Rebar Table Lookup

  • 15

I have a Rebar table with a header column, A3:A12, of bar sizes and a header row of placement spacing, B2:I12.

The table consists of weights per square foot.

I want to return a value in a cell if I input the bar size in a cell and the spacing in another cell.

Any suggestions on how to do it with either “V or HLookup”?

Share

    1 Answer

    1. I’m not exactly sure what you mean by “a header row of placement spacing, B2:I12.”

      B2:I12 is not a “header row” it’s a range of rows and columns.

      If you are trying to return a value found at the intersection of a value from Column A and a value from Row 2, try using INDEX and MATCH.

      Here’s just one of many sites that explains how it works…

      http://www.mbaexcel.com/excel/how-t…

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0