I have two files which look like this:

File 1

File 2

  1. I need to insert missing data (fields PART, WEIGHT, MIN QTY, DISCOUNT) from the first file into the second if the NUMBER field matches.

  2. I need to insert PRICE 1 from the first file into PRICE 2 on the second file if NUMBER field matches.

Is there a way to do that in excel or should I be looking into other apps (like Access maybe) ?

  • Use a conditional formula after bringing the data into the same sheet. – var firstName Jan 11 at 20:04
  • Look at the VLOOKUP function. Use it for each column you want to retrieve. – fixer1234 Jan 12 at 16:40
  • have a look in this .. and share if you stuck at implementing it.. – p._phidot_ Jan 15 at 2:43

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.