Formulas

CONCATENATE 

= CONCATENATE(text 1, text 2,…) → see COMBINING & SPLITTING TEXT

Generate Random Number

= RANDBETWEEN(bottom, top)

IF Statement

= IF(logical_test, [value_if_true], [value_if_false])

INDEX-MATCH

= INDEX(array, row_num, [column_num],MATCH(lookup_value, lookup_array, [match_type])

VLOOKUP

= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Advertisements