thinksuccess
New Member
- Joined
- Jan 29, 2003
- Messages
- 16
Hi,
I have 2 worksheets each with a common column and would like to match the columns and if there is a match take a value from the matching row in sheet 2 and place it in a new column in sheet 1
So it wouldl be like this:
Sheet1
Column A Column B (New Column)
Sheet2
Column A Column B Column C
So if Column A matches in sheet 1 and 2 take Column C in sheet 2 and place in Column B of sheet 1
Thanks
I have 2 worksheets each with a common column and would like to match the columns and if there is a match take a value from the matching row in sheet 2 and place it in a new column in sheet 1
So it wouldl be like this:
Sheet1
Column A Column B (New Column)
Sheet2
Column A Column B Column C
So if Column A matches in sheet 1 and 2 take Column C in sheet 2 and place in Column B of sheet 1
Thanks