Please enable JavaScript.

Coggle requires JavaScript to display documents.

1:14 index (2 forms (Here (First), Array (= (Reference (Non congrumet…

- - - - Reference
        
        ==> searched range/s
        
        Non congrumet
        
        Possible
- - - - Assume
        
        Know
        
        Where
    - - Value
  - - - What
    - - Where
  - - - Of
        
        Index
    - - Of
        
        Pulling
    - - Value
        
        Address
    - - Complement
        
        Of
        
        Index
- - - - Vlookup
      - Hlookup
      - Faster
      - Resilienter
  - - - ==>
        
        Index(B5:AA22, Match(animal), Match(zoo))
  - - - Apples. Cherries. Grapes. Watermelon.
    - - 48
- - - - 1D
  - - - 2D
- - - - Book
        
        Pages
      - Page
        
        Number
    - - Page
        
        Content
- - - - Range
      - Relative
        
        Address
        
        To pull
        
        Result
- - - - Col
        
        ||
        
        Row
      - Number
        
        Cell
        
        Step-into
        
        Data
        
        Col || Row
      - :fishing_pole_and_fish:
        
        Apples. Cherries. Grapes. Watermelon
        
        Index($b$3:$e$3, 3)
        
        =
        
        Grapes
        
        Row
        
        $b$3:$b$6, 3
        
        Same
        
        Result
      - row number
        
        =
        
        index number
    - - Row
        
        Start
        
        Top
        
        At
        
        1
        
        Down
        
        How
        
        Many
- - - - Area
        
        Look in