B
bill gras
i have in sheet K column C row 3 to row 240 names eg:
sheet K
C
3 joe
4 adam
5 reon
6 bill
7 ian
and so on
in sheet RC column A row 2 to row 1001 i have multiple
names of the same names as in sheet K , and in columns
BB and BC i have values eg:
sheet RC
A BB BC
2 joe 8.3
3 joe 8.3 120
4 joe 8.3
5 joe 8.3
6 joe 8.3
7 adam 0.2 140
8 adam 0.2
9 reon
10 reon
11 bill 3.7
12 bill 3.7
13 bill 3.7 90
14 bill 3.7
15 ian 2.9 110
16 ian 2.9
down to 1001 rows (columns are at random sequences)
i need to have a name in sheet K to match the names
in sheet RC and return what is in columns BB ans BC to
columns k and L in sheet K eg:
sheet K
C k L
3 joe 8.3 120
4 adam 0.2 140
5 reon
6 reon
7 bill 3.7 90
8 ian 2.9 110
and so on
can some one help me please ?
bill gras
sheet K
C
3 joe
4 adam
5 reon
6 bill
7 ian
and so on
in sheet RC column A row 2 to row 1001 i have multiple
names of the same names as in sheet K , and in columns
BB and BC i have values eg:
sheet RC
A BB BC
2 joe 8.3
3 joe 8.3 120
4 joe 8.3
5 joe 8.3
6 joe 8.3
7 adam 0.2 140
8 adam 0.2
9 reon
10 reon
11 bill 3.7
12 bill 3.7
13 bill 3.7 90
14 bill 3.7
15 ian 2.9 110
16 ian 2.9
down to 1001 rows (columns are at random sequences)
i need to have a name in sheet K to match the names
in sheet RC and return what is in columns BB ans BC to
columns k and L in sheet K eg:
sheet K
C k L
3 joe 8.3 120
4 adam 0.2 140
5 reon
6 reon
7 bill 3.7 90
8 ian 2.9 110
and so on
can some one help me please ?
bill gras