Solved Excel Rebar Table Lookup

January 22, 2014 at 09:14:10
Specs: Windows 7
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"?

See More: Excel Rebar Table Lookup

Report •

January 22, 2014 at 20:55:00
✔ Best Answer
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...

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

Report •

January 23, 2014 at 05:51:41
Your solution is exactly what I was looking for. Thank you.

Report •
Related Solutions

Ask Question