Forum Discussion

g_avinash's avatar
g_avinash
Copper Contributor
May 19, 2023
Solved

Fuzzy lookup multiple criteria

Hi, First entry for a sales record is 26,695 rupees. Later, when I receive the money, I record a receipt entry for the whole amount (as in sales) or a smaller, roughly equivalent amount. Bu...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 21, 2023
    there are a few options. I just copy useful formulas to a single workbook so I know where to find them.
g_avinash's avatar
g_avinash
Copper Contributor
May 21, 2023

Thank you very much!
Sir, how to reuse the lambda function. Where can I save the custom formula "NearMatches" that you have created? so that I can reuse the same formula in other workbooks.

mtarler's avatar
mtarler
Silver Contributor
May 21, 2023
there are a few options. I just copy useful formulas to a single workbook so I know where to find them.
  • g_avinash's avatar
    g_avinash
    Copper Contributor
    May 21, 2023

    Your advice has been really helpful to me. I owe you a great deal. Once again, thank you sir mtarler.

Resources