You can't put formulas into csv-file. It is a text file!

You need a separate Excel file, and you copy data from scv-file into Excel file, or for every export you convert (with Save As) the csv-file to excel file, and then add formulas into it.

In attached file is an example, how you can read info from another table (Users) based on some ID field (PersonŃame). You have to be aware, that;

The 1st occurrence of key field (PersonName) in lookup table (Users) is referred. When you have several John Smith's (When you are from English-speaking country, you have more than 10 users, and there really is user John Smith, then there is very high probability you have several different persons with name John Smith ), then you get for all of them same result (Username) returned;

The searched ID's must match absolutely! A single typing error, and no match is found;

In lookup range (users table), the leftmost column must be the ID you use to look for (PersonName). 3rd parameter of formula indicates the number of column with return value in lookup table (2nd column in users table is Username). 0 as 4th parameter means, that exact match is wanted. Other values for this parameter assume, that the lookup table is ordered, and that you know what you do.

Attached Files

VLookupExample.xlsx (11.3 KB, 11 views)