how to multiple vlookup from input sheet to output sheet

Dear all, i have two sheet , input and output.need vlookup formula match any three cell data of input sheet , then result to output sheet
if match then. input sheet is like bellow

Roll-1 Roll-2 Roll-3 Name Father's Name Mother's Nmae Contact
2010-6-1 2011-7-2 2012-8-3 Nur Razzak Mojinur 01678102069

output sheet results like bellow

VLOOKUP(A2,input!A:G,4,0) if A2=2010-6-1 then output result will be Nur
or
VLOOKUP(A2,input!A:G,4,0) if A2=2011-7-2 then output result will be Nur
or
VLOOKUP(A2,input!A:G,4,0) if A2=2012-8-3 then output result will be Nur


BR/nur

try this, copied down and across...
=INDEX(input!$A$1:$G$4, IF(ISERROR(MATCH(input!$A16,input!$A$1:$A$4,0)), IF(ISERROR(MATCH(input!$A16,input!$B$1:$B$4,0)), MATCH(input!$A16,input!$C$1:$C$4,0),MATCH(input!$A16,input!$B$1:$B$4,0)),MATCH(input!$A16,input!$A$1:$A$4,0)),MATCH(B$1,input!$A$1:$G$1,0))

sorry, i was referencing the wrong cell due to a copy mistake, change the formula to this...
=INDEX(input!$A$1:$G$4, IF(ISERROR(MATCH(output!$A2,input!$A$1:$A$4,0)), IF(ISERROR(MATCH(output!$A2,input!$B$1:$B$4,0)), MATCH(output!$A2,input!$C$1:$C$4,0),MATCH(output!$A2,input!$B$1:$B$4,0)),MATCH(output!$A2,input!$A$1:$A$4,0)),MATCH(B$1,input!$A$1:$G$1,0))

Hi,FDibbins
You did outstanding job for me. yes It is ! what i was looking for ! I appreciate your job..Br/nur

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

Shorter / Elegant Version:

Output B2: =INDEX(input!D$2:D$4,MAX(INDEX((input!$A$2:$C$4=$A2)*ROW(input!$A$2:$C$4)-1,)))

Copy across and down

Hi, Teethless mama
Its very well appreciated..