Home > OS >  EXCEL database, two EXCEL file how to match the same field data?
EXCEL database, two EXCEL file how to match the same field data?

Time:09-23

Suppose A file contains field 1 - keywords, 2 numerical fields, two columns,

Then another file B 1 - key words, there is also a field within 2 numerical fields, two columns,

Two files of field 1 into Chinese keyword data, there is a certain overlap, also have different individual keywords,

Demand: A file for the final output file, B file updates every day, need to numerical fields in the area by 2 B file, fill to A file within the same field 1 keywords,

CodePudding user response:

A file keyword if full, vlookup (... It is ok to) function; New if B file had to be added in A line, this how to do how to increase the,

CodePudding user response:

Use a VLOOKUP or write a macro to update
  • Related