VLookup from another workbook and return results from 3 columns

[Rodrigues]

Hi There
I'm trying to use this formula:
VLOOKUP(B3,[Source.xlsx]Sheet1!$A$3:$H$10,{6,7,8},FALSE) ; without success, could some please help me on this one?
Brief:
Have two files, one named "Formula" (where I have the Vlookup formula) and other named "source".
The formula file "Column B" has "left function" in it and works as a "lookup value";
Source file, "reference range" from external workbook;
original Source file contains hundreds of rows.
Formula:
Would like to on formula file, lookup value on B2 down and display on columns E;F;G, results from columns F:G:H source file.


Have attached example files.
Thanks in advance.
Regards
R

 

[vletm]

Rodrigues
Your challenge is that 'Source'-files 'Product Code' has some 'spaces' in the end.
Check with these...

 

[Rodrigues]

Hi vletm
Some of the rows doesn't copy properly, as you have mentioned probably due to the spaces on the source file.
Could you please let me know what [#All] after table1 does?
Anyway, thank you for your help.
Regards
R

 

[vletm]

Rodrigues
Not probably, that is fact!
'Rodrigues' is different than 'Rodrigues '.
You should take care those 'spaces' someway.

[#All] means ... all ... it means that range is the whole table.

 

[Rodrigues]

Thank you, very much appreciated.
R