C
catlair
Hi,
How do I match one data set from one spreadsheet (A) with another
spreadsheet (B) row by row and then fill into a new cell (in another
column) in spreadsheet A, data from a cell (from spreadsheet B) that
matches a row in spreadsheet B, using two (other) fields as a criteria
('AND' logic) in that row (from spreadsheet B) using a macro? Will the
lookup function be more appropriate than MATCH?
catlair
How do I match one data set from one spreadsheet (A) with another
spreadsheet (B) row by row and then fill into a new cell (in another
column) in spreadsheet A, data from a cell (from spreadsheet B) that
matches a row in spreadsheet B, using two (other) fields as a criteria
('AND' logic) in that row (from spreadsheet B) using a macro? Will the
lookup function be more appropriate than MATCH?
catlair