| 19.Lookup Reference functions | ||
| 19.1.ADDRESS( 7 ) | 19.9.INDIRECT( 4 ) | |
| 19.2.AREAS( 3 ) | 19.10.LOOKUP( 8 ) | |
| 19.3.CHOOSE( 5 ) | 19.11.Match( 4 ) | |
| 19.4.COLUMN( 7 ) | 19.12.OFFSET( 7 ) | |
| 19.5.FIND( 2 ) | 19.13.ROW( 5 ) | |
| 19.6.HLOOKUP( 4 ) | 19.14.TRANSPOSE( 1 ) | |
| 19.7.HYPERLINK( 1 ) | 19.15.VLOOKUP( 4 ) | |
| 19.8.INDEX( 7 ) | ||