Index and Match - Excel says function has too many arguments

[Sean15]

col A col B col C
USA John Peter 12
Mexico JOHN Peter 20
FRA John C Peter 25


John Peter return value should be USA

INDEX($A$3:$A$5, MATCH(True, Exact(B8, $B$3:$B$5, 0))



This formula is suppose to return value from column A based on case sensitives lookup value in B8
But Excel says function has too many arguments. Could someone take a look please?

Regards

Sean

 

[Marcelo Branco]

Try

=INDEX($A$3:$A$5,MATCH(TRUE,INDEX(EXACT(B8,$B$3:$B$5),),0))

M.

 

[Peter_SSs]

You are missing a ")" and need to confirm the formula with Ctrl+Shift+Enter
=INDEX($A$3:$A$5, MATCH(TRUE, EXACT(B8, $B$3:$B$5), 0))

or without C+S+E
=INDEX($A$3:$A$5, MATCH(TRUE, INDEX(EXACT(B8, $B$3:$B$5),0), 0))

 

[Sean15]

Thank you very much Marcelo Branco and Peter SS

Regards
Sean

 

[Peter_SSs]

Thank you very much Marcelo Branco and Peter SS

Regards
Sean

Cheers. Glad to help.