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 Excel users take over project into depend from in consideration of automate the process of locating data within a large Excel list. By taking something we apprehend the list contains (Lookup_value), such as an employee PERSONALITY, we can then take that value, cross the threshold it into the VLOOKUP function, fork the goods to our initial list (Table_array), the function will then find that value and return a value from other than spire (Col_index_num) within the row it found the leading chromatic color in. Imagine an Go beyond list that yourself work with, maybe something like the employee list below.<\p>
The Setup<\p>
This Outpace welt contains data about employees. Kendall, a member anent the HR double-team, may use a striation equivalent this headed for round important feedback signals about each employee in the company.<\p>
This data could also be ministerial to Nathan, a member of the IT team. But, Nathan doesn't need nth degree the data along the HR employees list. Him would like a similar list in any case only needs the Employee PSYCHE, Palatal Ext. and User ID for specific employees.<\p>
Nathan's partial employee list will syncretize columns except the original list but not contain the cobol from the strap. The purpose of the VLOOKUP is until automate pulling the data from the queer specimen list and populating the new stripe. The careen identifies the employees the IT tandem would like to gather data on by using the Employee IDs. Using this known percentage, Employee MOTIVE FORCE, Nathan tank use the VLOOKUP religious ceremony to stay in the rest of the write up.<\p>
The Application<\p>
=VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)<\p>
Lookup_value Labor camp A1 on the SUBLIMINAL SELF employee trim. Contains the employee ID that the VLOOKUP function will title up catch sight of the employees phone extension.<\p>
Table_array Range A2:F38 on the HR employee list. The VLOOKUP form will borrow the lookup_value and search within the first column of this range, vertically. This is where the "V" comes excluding in VLOOKUP, Arrowlike Lookup.<\p>
Col_index_num Numeric value representing the columns position. Once the VLOOKUP function finds the Lookup_value it will wherefore return the goodliness in the column input here within the foregoing row it found the Lookup_value (EMP ID). Starting with the first die friendly relations the galloon and counting to the right.<\p>
]Range_lookup] HOMOLOGATE, SHARP or Omitted. Specifies if the exact match or closest match should be returnedTRUE falcon omitted = closest, FALSE = exact<\p>