vlookup tool

VBA Vlookup We will be importing data into the SALES spreadsheet using data from one of two files. Amazon and ShipStation. Column W in the SALES spreadsheet contains the order number. This is the KEY When the application is run the user will select the source file and column number that contains the KEY data to search. Example [login to view URL] / column A 1) If the user selects column A as the Key. The program will pick an order number from column W in the SALES spreadsheet and try to locate a match in column A in the source file. If none is found it will do nothing. If a match is found it will import the following fields into the matching SALES spreadsheet row. A message should display showing the status of the import. X found and imported. Source file column – destination file column C – B I - C M – E N- F R – N S – P X – R V – S W – T Y – U 2) If the user selects column AV. Similar function. The program will search for a matching order number in the source file and column AV in the source file. If none is found it will do nothing. If a match is found it will import the following fields into the matching SALES spreadsheet row. A message should display showing the status of the import. X found and imported. Source file column – destination file column AS – B BM – C Z – E CD – F BE - M BG – N AF – P X – Q AL – R AI – S AM – T AG - U