I am trying to do the follwoing wihtout using VB in Excel. I am not familiar with VB so I am wondering if anyone would know how to accomplish this using Excel functions.
If a cell in column A of workbook 1 matches a cell in column A of workbook 2 AND a cell from column B in the same row as the cell from column A match of Workbook 1 matches a cell from column B in same row as the column A match of Workbook 2, I need to bring the value from column C of workbook 2 to Column C in workbook 1 on the same row where that had the matches for column A and column B.
For example, if A2 of workbook 1 matches A9 of workbook 2 and B2 of workbook 1 matches B9 of workbook 2 then I need to bring the value in C9 of workbook 2 into C2 of workbook 1. If any one of the four rows in this example were not the same, column C of the row in workbook 1 would remain empty.
In case it matters, values in Columns A and B of both worksheets can be any combination of letters and numbers. Values in Column C fo workbook 2 would be formated for currency or accounting.
Thanks,
dougc
If a cell in column A of workbook 1 matches a cell in column A of workbook 2 AND a cell from column B in the same row as the cell from column A match of Workbook 1 matches a cell from column B in same row as the column A match of Workbook 2, I need to bring the value from column C of workbook 2 to Column C in workbook 1 on the same row where that had the matches for column A and column B.
For example, if A2 of workbook 1 matches A9 of workbook 2 and B2 of workbook 1 matches B9 of workbook 2 then I need to bring the value in C9 of workbook 2 into C2 of workbook 1. If any one of the four rows in this example were not the same, column C of the row in workbook 1 would remain empty.
In case it matters, values in Columns A and B of both worksheets can be any combination of letters and numbers. Values in Column C fo workbook 2 would be formated for currency or accounting.
Thanks,
dougc