Vlookup issue

Look at the attached. I basically copied file 1 and pasted the SKU's and UPC's codes. Then I did a vlookup in the pricing column and quantity.

Tacape, if I had to work with this information, I would simply update the qty value in File 1 with the qty data from File 2 with a VLOOKUP then perform a file save as... to save File 1 as File 3.

Here is the VLOOKUP I would use to update the QTY field in File 1:

=VLOOKUP(A2,'File 2'!A:C,3,FALSE)

This is referencing the SKU field, if you wanted to use the UPC field, your VLOOKUP would be this:

=VLOOKUP(B2,'File 2'!B:C,2,FALSE)


Good luck!