Lookup Function Used To. A value that lookup searches for in an array. There are two ways to use a lookup formula depending on your needs.
Lookup value required function this is the value that we will be searching. The lookup value argument can be a number text a. Let s say you have a simple list of 1000 clients with three columns.
It uses the following arguments.
If lookup can t find the value of lookup value it uses the largest value in the array that is less than or equal. Vlookup a2 a10 c20 2 true vlookup fontana b2 e7 2 false vlookup a2 client details a f 3 false. It uses the following arguments. Last name phone number and age.
