Multiple Column look up and value return using index match

[Keegan4123]

I am building a rate sheet generator using a stored rate list.
I would like the user to be able to select a company name from a drop down, and the formatted rate sheet would automatically populate the required columns.

I have the main rate sheet setup with a named table and can use the match to properly find the right column, however I can't figure out how to then use that column number to search and return values in the sheet.

The first few columns in the table directly connect to the later columns in the table. Ive spent more time on this then I am proud to admit.
I cant figure out how to upload the actual xls file and I cant use the mini app as our network admin has them locked down

 

[Keegan4123]

I should add. This is all in the same workbook, just differnt tabs. The data set is formated as a table.