Trouble with Index and Match functions

[hiandhello9]

Im trying to get the wind pressures to show up when I choose from a drop down menu. I attached the workbook I'm needing help with. I'm trying to do an index and match lookup from the charts on the other sheets.

[southward]

Hi,

Using a combination of removing merged cells, concatenating cells into helper cells and a helper column this formula works.

Please Login or Register  to view this content.

See attached revised file.

Hope it works for you.

[southward]

Made changes to the Building Height list. It is restricted to only values that could be applied to the combination of the other categories.

[southward]

I couldn't leave it half done.
Attached is a complete working version.

Let me know if you have any issues with it.

Hope it helps