LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default multiple match

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a Match in Multiple Places & Return Multiple Values Toria Excel Worksheet Functions 3 June 24th 08 09:49 PM
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com Excel Worksheet Functions 27 October 6th 07 01:39 AM
Index & Match functions - multiple criteria and multiple results [email protected] Excel Worksheet Functions 4 May 2nd 07 03:13 AM
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec TravisB Excel Discussion (Misc queries) 21 March 16th 07 09:49 PM
How do I add multiple values that match multiple conditions? Joel Excel Discussion (Misc queries) 5 April 10th 06 01:32 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"