AMATCH

[Brett]

Does anyone know where to find information about the AMATCH function? There
is no help available in my excel help files on how to use this function. I
tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
results were found".

 

[Dave Peterson]

Maybe you mean =match()?

You can refer to Excel's help and Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html

 

[Ron Rosenfeld]

Does anyone know where to find information about the AMATCH function? There
is no help available in my excel help files on how to use this function. I
tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
results were found".

AMATCH is not a built-in Excel function. Most likely it is a UDF (user-defined
function) and you would have to speak to whoever wrote the code for it.


--ron

 

[Debra Dalgleish]

Charles Williams' FastExcel has an AMATCH function. Maybe that's it:

http://www.decisionmodels.com/FxlV2WhatsNew.htm

 

[Gord Dibben]

Brett

Search the 'net.

You will find references to AMATCH in PERL for fuzzy matching.

Definitely not an Excel Function.


Gord Dibben Excel MVP