VLOOKUP Simulator

How this compares to Excel VLOOKUP

Excel VLOOKUP looks up a value in one table and returns a value from another column in the same row. This tool applies the same idea to two full tables, then returns a merged output you can review and download. In database terms, it behaves like a lightweightleft join: every row from the base table stays in place, and matching columns from the lookup table are appended.

How to use the simulator correctly

Paste your base table on the left and the lookup table on the right. Choose the key column from each dataset, run the join, and inspect the match count before downloading the CSV. The tool works best when both key columns use the same formatting. If one table stores customer IDs as 00123 and the other stores them as 123, clean the keys first.

Common reasons VLOOKUP-style joins fail

• Leading or trailing whitespace in the key column.
• Different casing for text-based identifiers.
• Duplicate keys in the lookup table.
• Different formats for dates, codes, or padded IDs.

Left join behaviour and duplicate keys

All rows from Table 1 are kept. Rows that match in Table 2 receive the extra columns. Rows with no match receive blanks in the appended fields. That makes this useful for finding missing reference data as well as merging complete records. If the lookup table contains duplicate keys, you should deduplicate it first so the result is deterministic. For operational work, treat key hygiene as part of the join itself.

Related tools and guides

• CSV Cleaner to trim whitespace and remove obvious duplicates before joining.
• Remove Duplicate Lines if the lookup table contains repeated identifiers in raw text form.
• Data Type Detector to check whether both key columns are stored consistently.
• Data Quality Guide for a broader workflow around joins, validity, and completeness.