what is vhlookup fr?

VHLookup Local is a Windows desktop tool built for public agency, school, HR, and finance staff who spend a lot of time cleaning, combining, checking, and summarizing Excel files by hand. It is aimed squarely at non developers: you download a zip file, unzip it, and double click the program inside, no Python or coding knowledge needed. The tool runs only on your own computer. It never modifies your original file, does not use any server, API, or cloud upload, and always lets you pick where the result file is saved yourself. It offers seven main features. The first automatically finds columns that look like personal information, such as names, ID numbers, phone numbers, emails, and birthdates, lets you confirm which ones to hide with checkboxes, and replaces the values with asterisks matching the original length. The second splits one spreadsheet into multiple sheets based on a column you choose, such as department or status. The third merges several Excel or CSV files together, either by stacking similar files or by joining columns using a shared key column, and it can suggest matching columns even when their names differ but their values overlap. The fourth feature compares a before and after version of a file and highlights added rows in blue, removed rows in red with strikethrough, and changed cells with notes, even if column names changed between the two files. The fifth feature converts a wide table with separate columns for each month or quarter into a simple list format. The sixth builds pivot style summary tables grouped by department, month, or status, with count, sum, average, minimum, or maximum options. The seventh, added in the newest version, lets you pick a column and manually reorder its unique values, then sorts the whole spreadsheet to match that custom order, useful for things like department rank or status priority. Because the released executable is not code signed, Windows SmartScreen may initially warn against running it, and the README explains how to verify the file using its published SHA256 checksum.