select multiple criteria multiple worksheets
I have two worksheets along the lines of:
SHEET 1 SHEET 2
A B C D A B C D
1 1 10 100 1 10 100
1 3 20 - 1 20 -
2 6 20 300 1 30 200
2 9 30 200 2 20 300
2 9 30 200 3 10 100
3 11 10 100 3 10 200
3 11 10 200
I want to fill incolumn "B" on Sheet 2 with the values from column B in
sheet 1 whereever columns A, C, and D match.
Any ideas on how to do this?
thanks.
|