vlookup and hlookup

[mathcadboy]

Hello, is there a way in mathcad to use vlookup that the value that it looks up is not on the first column? because in excel I do something like this :

=INDEX(A2:A6,MATCH("Belfast",C2:C6,0))

Is there a way to do this in mathcad?
thanks in advance to anyone that can help

 

[Occupant]

Do you mean something like Res:=match(z,M)?

 

[Gumpmaster]

I just insert my excel sheet as a component in MathCAD and read variables into and out of Excel. Then you have all of your familiar Excel functions.