Lookup Function Used To. The vector type searches only one row or column while an array searches multiple rows and columns. This article describes the vector form.
A value that lookup searches for in an array. It can be used as a worksheet function ws in excel. Let s say you have a simple list of 1000 clients with three columns.
That s when the lookup function can be useful.
As a vector and an array. Result vector an. The lookup function is a built in function in excel that is categorized as a lookup reference function. The vector type searches only one row or column while an array searches multiple rows and columns.
