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?
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.