Vlookup issue

Originally Posted by TMShucks

Alternatively, just copy file 1 and make it file 3. Then replace the existing quantity values with a VLOOKUP to get the new quantity field from file 2.

Hi TMS,

thank you so much for taking the time to read and respond. I am interested in the alternative option you provided. If I was to copy file 1 and make it file 3, and look up quantity from file 2, what would be the vlookup formula? Let me attach a sample for you to take a look at. I tried several vlookups but was never able to get correct result.

Thanks in advance.

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!