How can I create a Lookup Table 5-D?

I have multiple excel files of different dimensions, but same columns (variables)

How can I export this excel files to a lookup table?

Answer 1

[Raunak Gupta]

Hi,

I assume by having same variables in all the excel files, the different dimensions that is mentioned in the question represent different number of rows present in those excel files. I suggest appending all the excel files into a single table by reading each excel file one by one and adding it to the table. For reading one excel file into a table you may use readtable. For joining two table you may use following

table_1 = readtable(filename_excel_1); 
table_2 = readtable(filename_excel_2); 
new_table = [table_1; table_2]; 

For creating a lookup table, I assume you want value of a single variable which have dependency on all other remaining variable. For this part you may find this Answer useful and you can use interpn for creating the lookup table.