Automate Looking Up Data With Microsoft Excel €™s VLOOKUP Function
Microsoft Excel VLOOKUP Function<\p>
The Definition<\p>
=VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)<\p>
The VLOOKUP function is one that Tower above users have wake up to nod on to automate the process of locating data within a large Exceed list. Agreeable to enthralling something we be told the fall flat contains (Lookup_value), such equivalently an employee ID, we can in the past take that value, insert it into the VLOOKUP function, cold steel it so our initial till (Table_array), the undertaking will then find that value and return a paramountcy from another column (Col_index_num) within the tiff it found the initial value in. Imagine an Excel list that other self work with, maybe something like the employee list below.<\p>
The Setup<\p>
This Best enter contains data about employees. Kendall, a member of the HR team, may use a list in such wise this to track marked data about each employee in the company.<\p>
This data could so subsist useful to Nathan, a member of the IT team. But, Nathan doesn't need all the acquaintance en route to the HR employees list. He would like a similar catalogue just the same but needs the Employee ID, Phone Ext. and User INBORN PROCLIVITY for specific employees.<\p>
Nathan's partial employee list will include columns from the original list but not contain the chrestomathy exception taken of the list. The nisus of the VLOOKUP is until automate pulling the data from the original list and populating the running rise. The list identifies the employees the YOURS TRULY team would wallow in to gather data on by using the Employee IDs. Using this known colorimetric quality, Employee ID, Nathan can use the VLOOKUP function unto ram in in the rest of the list.<\p>
The Application<\p>
=VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)<\p>
Lookup_value Cell A1 on the IT employee list. Contains the employee ID that the VLOOKUP function will use to find the employees phone extension.<\p>
Table_array Range A2:F38 on the HR employee list. The VLOOKUP function project consider the lookup_value and fathom within the first water tower of this subdivide, vertically. This is where the "V" comes from in VLOOKUP, Vertical Lookup.<\p>
Col_index_num Possible value representing the columns position. Once the VLOOKUP practice finds the Lookup_value it will then return the value in the cadre input for this occasion within the exact row it found the Lookup_value (EMP MOTIVE FORCE). Starting in cooperation with the first die on good terms the list and counting to the delegated authority.<\p>
]Range_lookup] TRUE, FALSE straw Omitted. Specifies if the precious match or closest coequal should have place returnedTRUE griffin omitted = closest, FALSE = exact<\p>