|On the two documents, one header spans the first 6 rows, the other uses the first three rows. Will that make a difference?|
You must modify the formula to start at the different location.
I specified only one header row in my formula,
=VLOOKUP(A2,'Finished Goods List2'!$A$2:$G$30,7,FALSE)
So the modified formula should be something like:
Note the differences.
See the single quote marks around the Finished Goods List name?
In my original formula, I used spaces between the words, thus the need for single quote marks.
And don't forget that after you finish, do a Copy / Paste Special / Values
on column G.
The formula is currently set from row 7 to row 30.
See if that work.