I am trying to find an alternative to the Match function as I am using a software that does not support it.

I have two sheets, one is a company trading statement where you can choose the company you are looking at, at the top from a drop down. The next sheet then has a list of all the companies down the left hand side and the different accounts from the trading statement along the top.

At the moment I am using a match function to find the row of the chosen company on the second sheet, within a HLOOKUP function that uses a given account on the trading statement as its lookup value.

Would anyone please be able to help me find an alternative way to do this without using the Match function?