I am having trouble with the
vlookup function in excel.
I have 2 files: file1.xlsx and file2.xlsx. Both files have a list of products with a number of various information and I need to add values from file2 to products in file1 (paired based on the product name).
I have tried the following formula:
but keep getting a value error.
The first value is the name of the product in file1, second value is the
filename of file2, name of the sheet and the range which should be used for lookup and the third value is the number of the column from which data should be returned.
Is there something obvious that I am overlooking please? The value to be returned is a string.