The vector form searches for a value in a single row or column and returns a corresponding value from another row or column, while the array form works with larger table-like data ranges.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback