Vlookup Tool
Free online tool simulating Excel Vlookup to find and match data.
Tool Guide
Introduction
An online VLOOKUP data lookup tool that provides vertical lookup functionality similar to Excel's VLOOKUP function, merging two related datasets into a single complete new dataset via a specified key field.
How to Use
Copy the data you want to look up row by row from Excel into Table 1, and copy the reference data into Table 2. Set the position of the matching data column in Table 1 and Table 2 as appropriate, then click the button to complete the processing. Once processing is done, you can copy and paste the data directly into Excel or export it directly to an Excel file. Click to view a usage demo.
VLOOKUP is a vertical lookup function in Excel. Together with the LOOKUP and HLOOKUP functions, it belongs to a family of functions that are widely used in work — for example, to verify data or quickly import data between multiple tables. Its purpose is to look up by column and return the value corresponding to the required lookup entry in that column; its counterpart, HLOOKUP, looks up by row.
The function's syntax rules are as follows:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)