cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are working to address an issue with subscription email notifications. In the meantime, be sure to check your favorite boards for new topics.

rebar

EN_9902818
6-Contributor

rebar

Hi,

 

I have created the attached worksheet for rebar choosing but not sure how it can show the rebar area at the end.

 

I'm choosing the rebar size and i have the area for various distances. After this I'm choosing the pitch.

Any idea how this could return back the As?

 

thanks,

1 REPLY 1


@EN_9902818 wrote:

Hi,

 

I have created the attached worksheet for rebar choosing but not sure how it can show the rebar area at the end.

 

I'm choosing the rebar size and i have the area for various distances. After this I'm choosing the pitch.

Any idea how this could return back the As?

 

thanks,


You're not matching correctly, because the rebar pitch isn't in the rebar area matrix.

 

Is the attached of any help?  I've changed the rebar pitch to return an index into rebar area, and also provided another variant that augments the rebar pitches to the rebar area matrix and then performs a vlookup.

 

Cheers,

 

Stuart

Top Tags