Alternative to MATCH function?

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?

Hello,

yes sorry here is a link to the supported functions in TM1..

http://www.ibm.com/support/knowledge...nctions_NE0019

Thanks!

Hello,

yes sorry here is a link to the supported functions in TM1..

http://www.ibm.com/support/knowledge...nctions_NE0019

Thanks