Need help for excel 2007

[adikoldskool]

SHEET 1 CONTAIN DATA AS SHOWN BELOW:
CONCATENATE OF THE NAME AND DATE OF BIRTH
_______
COLUMN A1:HEADING
COLUMN A2:MARIA08AUG
COLUMN A3:MARIA08AUG
YEAR OF WORKING EXPERIENCE
_______
B1:HEADING
B2:9
B3:7
WORKING PLACE
_______
C1:HEADING
C2:ROBINSON
C3:JOHN LITTLE
*
SHEET 2 CONTAIN DATA AS SHOWN BELOW:
A1: HEADING
A2: MARIA
B1: HEADING
B2:08AUG
C1: HEADING
C2: MARIA08AUG -> CONCATENATE OF A2 AND B2
D1:

I want to find out the maximum number of working experience but the result in D1 will be "ROBINSON" instead of the number of working experience which is "9". hope any of you guys
can help out the solution. thank you
*

 

[Robert Mika]

No very clear but try this in D1 sheet2:
Array formula confirm CTRL+SHIFT+ENTER:

=INDEX(Sheet1!$A$2:$C$3,MATCH(MAX(IF(Sheet1!$A$2:$A$3=ShEet2!C2,Sheet1!$B$2:$B$3)),Sheet1!$B$2:$B$3,0),3)

 

[scottylad2]

Excel Workbook
	A	B	C	D
1	heading1	heading2	heading3
2	MARIA08AUG	9	ROBINSON
3	MARIA08AUG	7	JOHN LITTLE
4
5
6
7
8
9	HEADING	HEADING	HEADING	heading4
10	MARIA	08AUG	MARIA08AUG	ROBINSON
Sheet3

hopefully i've interpreted what you want