computing
  • 0

Solved Excel Rebar Table Lookup

  • 0

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