S
scrabtree
I have a range of cells in Sheet1 A1:Z100. In Sheet2, in
Cells A1, B1, C1, and D1 there will be four values (the
first three values will be listed several times in Sheet1
Columns A,B, and C respectively).
I need a code that will look down Sheet1 Column A, Column
B and Column C and find the rows where only the adjacent
cells in Columns A, B, and C match the values in Sheet2
A1, B1 and C1 (only in a few rows will the adjacent cells
in Columns A, B and C match the values in Sheet2, A1, B1
and C1 exactly).
I then need it to look out these rows and count the cells
between Columns C:F that match the value in Sheet2 Cell
D1. I need this answer to be lodged in Sheet3 Cell A1.
Please help...and thanks in advance.
Cells A1, B1, C1, and D1 there will be four values (the
first three values will be listed several times in Sheet1
Columns A,B, and C respectively).
I need a code that will look down Sheet1 Column A, Column
B and Column C and find the rows where only the adjacent
cells in Columns A, B, and C match the values in Sheet2
A1, B1 and C1 (only in a few rows will the adjacent cells
in Columns A, B and C match the values in Sheet2, A1, B1
and C1 exactly).
I then need it to look out these rows and count the cells
between Columns C:F that match the value in Sheet2 Cell
D1. I need this answer to be lodged in Sheet3 Cell A1.
Please help...and thanks in advance.