Help, debugging problem

Hello, I am fairly new to vba coding and I am looking for some help.
Ive posted the code im trying to debug or fix. Im not quite sure the proper term, I am actually a mechanical engineering student so ya lol.
The purpose of my code is I have a set of table values with different variables that have values throughout the table. The variables being t, h, u, and so. I have written the code so that the user of the code can go to the formulas tab in excel and pull these table values by using a function through vba coding. The coding will also interpolate values if the value the user wants is not exactly in the table or array I have listed. My problem with my code is when i try and test it, and insert a value into the formula in excel, and it just says error value. I know the value exists because the value is in the array exactly, I have been staring at my code for a while and trying to debug it but I cannot find the issue. I have tried this code on another set of table values and it does work on that one only. I am not sure why that code works and this does not, as they are almost identical except with different array values.

Can someone please point me in the right direction, and possibly explain why my code does not work. I have had no training in vba or have any books on how to code in vba, so I would like to learn from this mistake.
Thank you, have a nice saturday!

Please Login or Register  to view this content.

oh duh lol, thanks haha