I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file.

As an example, the import file that has been provided includes an account number and does not include the Bank Code.  I would like to obtain the Bank Code from the GL_Bank table based on the Account number (BankAccountNo) that is provided to me on the input file.