How to use index() and match() with 3 parameters?

[alfa_eng]

Hello.

I've got a table that I need to know three parameters before I can consulte them, e.g I need to know the:
-diameter
- height
- time exposure to fire

Only after I know that I can get the value that I need that it is on the table.

When I only need to know 2 things before consulte tables, I use index() and match() together, but with 3 parameters that function together doesnt solve my problem.

Please guys, can anyone help me?
thanks

 

[Special-K99]

Attach a sample spreadsheet, remove any sensitive data.

You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

 

[alfa_eng]

I'm sorry but I dont know how to do that. I'm not used to work with online storage sites and I understand that my doubt is quite confusing, so I'm going to try to explain better.

I have a table on excel. I need the information that are on that table.
For me to "consulte" the table I need to know the diameter of a steel bar, the height of that bar and the time that bar can be exposure to fire, if I know that 3 things I can consulte the table and take the value of the resistance of that bar.

The table has 4 areas:
- a column with diferent diameters
- a columns with the heights
- a line with the time exposure
- and in the midlde diferent values of resistance

And I want that values on the middle. Imagine if I only needed to know the diameter and time exposure do fire to know the resistance I would use index() and match() but because I have an extra column I dont know how to cross these information! :/

I dont know if I'm being more clear now.
Thanks for your help anyway.