String inside Match Index

[BHudPE]

I have been going in circles. I fear I am making this more complicated than it needs to be. I would appreciate some solutions or suggestions.

What wksht needs to do: select a post size to suppport a beam, based on total load calc'd elsewhere. In Wksht:Beam Table, a row includes 3 criteria and the total load. I want code to search the data in Wksht:Post Tables and return the post size that has capacity > the total load.

I have separated the data sets into 16 tables in Wksht:Post Tables.

On my example data, the 3 criteria tell me "Table 11" is the table I want to use to select the post [see cell V15].

Question:
I want to use a string

Please Login or Register  to view this content.

in place of the manually entered of "Table11" in Cols X Y Z

Please Login or Register  to view this content.

BTW, the 3rd Wksht:Post Tables AllinOne is an earlier version where I was tried the data all together (previous to adding rows to create eaier to read tables.

[NBVC]

Just replace the Table11 in your formulas with:

INDIRECT("Table"&V15)

[BHudPE]

sorry I forgot to attach the file.
Here it is

[BHudPE]

thx NBVC. I wish I would have asked hours ago.