How to map two tables

Originally Posted by laura6776

Thank you Richard for your answer. I have tried but I get this error message:
Attachment 767728

Please upload the workbook in which you get that message.

Originally Posted by laura6776

Here is the workbook. I have commented the formula you advised me to put in, otherwise it was not possible to save the file.

You did not use the formula I gave you.

You used

=IFERROR(VLOOKUP(D5:$G$14,2,FALSE),"")

In gave you

=IFERROR(VLOOKUP(A5,$F$5:$G$14,2,FALSE),"")

Your formula did not contain the first element of a VLOOKUP, i.e. the value to use in the first column of the range containing the data you want, i..e A5 which contains the ID. Furthermore the range you were lookingup was D5:G14 and not F5:F14