@MATCH Function?

[JimM]

Hi

I've inherited a spreadsheet which has the following formula in it

=HLOOKUP($AZ$3,$C$13:$P$53,@MATCH(C16,$C$15:$C$53,0)+2,FALSE)

I'm happy with how it works but I've never seen the @MATCH phrase before, how does this differ from a straight MATCH statement ?

I've tried deleting the @ and the formula still works the same so it's not something obvious

Thanks

 

[Tom.Jones]

Hi,

You work with office 365 Insider?
I also saw that sign "@" in my

office 365 Insider.​

 

[Special-K99]

@MATCH

https://answers.microsoft.com/en-us...tch-mean/899f9345-71c7-4f72-89c0-fbfe492f32fc

I have no idea what it means after reading this.

 

[Scott Huish]

Pretty sure, it's from Lotus 1-2-3.

You can in Lotus like fashion, enter @SUM(A1:A3) but it converts it to Excel format.

 

[DataBlake]

Lotus is a lot like Visual Basic. "@Matches" is syntax used to match strings and patterns in that language, but it's weird that they kept the @ symbol but got rid of the "es". If it works it works though excel should change "@" to "=" when calculating.