Using Match and Vlookup to find the lookup range for a Vlookup

Hi,

I dont have the actual data as I am working on this for a colleague and
they are hesitant to release a copy of company data (despite being told that
no one will have a clue what its about!)

The problem is that the columns change order every time. We cant help this
as the information is gathered from a customer.

I have attached my trial spreadsheet that I mocked up to try and solve the
problem. hopefully this will help you see where I was going in my solution.

As for Index Match, I am familiar with Match, but never had much need to use
Index, so I am not familiar with what it does, so I'll look into that!