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?
Something like this?
Dim iX As Long
iX = WorksheetFunction.CountA(Range("A:A"))
iZ=Application.WorksheetFunction.VLookup(iX,Workbooks("B.xls").Sheets("Sheet1").Range(),
2, False)
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?
Something like this?
Dim iX As Long
iX = WorksheetFunction.CountA(Range("A:A"))
iZ=Application.WorksheetFunction.VLookup(iX,Workbooks("B.xls").Sheets("Sheet1").Range(),
2, False)
catlair