Apr 04, 2018 · How to use the Formula property of a range object to insert a formula into a cell. The formula is text that begins with the equals = sign and is wrapped in quotation marks. 2. Apr 26, 2012 · If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll show you a few of those ways. Formulas in MS Excel. Formulas are the Bread and butter of worksheet. Without formula, worksheet will be just simple tabular representation of data. A formula consists of special code, which is entered into a cell. It performs some calculations and returns a result, which is displayed in the cell.