match single data with multiple data

[moin]

i have a problem but some data matches and some don't when i match data with multiple datas , can you please help? i have attached a a sample, red marked does not match while other match.

[martindwilson]

lookup Returns a value either from a one-row or one-column range or from an array.

[Fotis1991]

Do you use Excel2003?

[moin]

i use excel 2010

[dilipandey]

Hi Moin,

use below formula :-

=INDEX($A:$A,MIN(IF($C$4:$E$9=$C13,ROW($C$4:$E$9),"")))

enter this using ctrl shift enter key combination. thanks

See attached: Book1.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

[Fotis1991]

Try

=IFERROR(IFERROR(INDEX($A$4:$A$9,MATCH(C13,$C$4:$C$9,0)),INDEX($A$4:$A$9,MATCH(C13,$D$4:$D$9,0))),INDEX($A$4:$A$9,MATCH(C13,$E$4:$E$9,0)))