- The table array first column is where the value is looked for. The table array specifies the total area for the Column indexes able to be chosen (a3:c8 would be 3 possible indexes, but value is only searched in column a).
- The table array must include all value for the table you want to make use of
- Words can be returned, but not looked up
- A different sheet can also be referenced (added before the table array with !)
- I.e. (25.6, Sheet2!$A$1:$C$5, 3, False)
LEN function only works for one cell
Count and COUNTA functions count # of cells in an array that have numbers (and letters for COUNTA)
IF(Formula, Condition if true, Condition if false)
(SUM, COUNT, AVERAGE)IF will tie to an IF statement if one exists, otherwise, the criteria will be a function (i.e. c3>d3).
Merging 2 cells into one (first and last names, esp.)
(SUM, COUNT, AVERAGE)IF will tie to an IF statement if one exists, otherwise, the criteria will be a function (i.e. c3>d3).
Merging 2 cells into one (first and last names, esp.)
- =A1&B1 (this will not intuitively add spaces.
