Please enable JavaScript.
Coggle requires JavaScript to display documents.
2:12 VLOOKUP (STRUCTURE (COL_INDEX_NUM (VALUE (EXTRACT (FROM (COLUMN…
2:12
VLOOKUP
STRUCTURE
LOOKUP_VALUE
WHAT
SEARCH
TABLE ARRAY
COL_INDEX_NUM
VALUE
EXTRACT
FROM
COLUMN
NUMBER ...
OF
INTEREST
NUMBER
COL
TO
RIGHT
START
INDEX
1,1
CELL
MOST
UPPER
LEFT
[RANGE_LOOKUP]
OPTIONAL
TRUE
DEFAULT
APPROXIMATE
FALSE
EXACT
MATCH
ORDER
VERTICAL FIRST
==
TOP :arrow_double_down:
TO
BOTTOM
THEN
RIGHT :arrow_right:
ASSOCIATED
VALUE
LEFT-MOST
ALWAYS
DATA_ARRAY
COL
:red_cross:NECESSRLY
MOST
LEFT
BUT
IN
SELECTED
AREA
:fishing_pole_and_fish:
COL F
START
SELECTION
=
INDEX
1
1 more item...
HLOOKUP
INSTEAD
FIRST
LEFT
FIRST
TOP
SIMILAR
LOOK
V
VERTICAL
H
HORIZONTAL
COL_INDEX_NUM
COUNT
START
1
MOST
LEFT
VAL_LOOKUP
COL =1
FIRST
MATCH
TRUE
APPROX
ORDER
DECENDING
FIRST
HIGHER
&THEN
BACK
ONE
EQUAL
FINISH
SEARCH
NEED
TABLE
ORDER
ACENDING
ALPABETICH
"APPLES"
"APPLE"
FALSE
EXACT
33%
POINTS
:star: :fishing_pole_and_fish: :question: LIONS
ZOO
NUMBER
5
TERMINOLOGY
ARRAY
2 D
DATA
TABLE
1 D
DATA
LIST
ORGANIZED
TABLE
MUST
SEARCH
LIST
LEFT
VALUE
TO
RIGHT
DETERMINE-IF
VALUE
EXIST
:
SINGLE
COLUMN
INDEX_COLUMN
1
FLAG
"FALSE"
>