Search and return value from range?

[Richcom]

Hi Guys,
I need your help to find a clue how to build this formula to list Case numbers from returned surveys based on customer mobile number. Please see short example down below. I was trying few combinations of VLOOKUP, INDEX, MATCH, but without success. Any clue? Thanks. Rich.

[TABLE="width: 916"]
<tbody>[TR]
[TD="colspan: 4"] We sent surveys to group of customers[/TD]
[TD][/TD]
[TD]Surveys returned from mobile numbers …[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Description[/TD]
[TD]Case number[/TD]
[TD]Mobile1[/TD]
[TD]Mobile2[/TD]
[TD]Mobile3[/TD]
[TD]Surveys[/TD]
[TD]Search for Case number[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Descripton1[/TD]
[TD]123[/TD]
[TD]111[/TD]
[TD][/TD]
[TD][/TD]
[TD]333[/TD]
[TD]Formula?[/TD]
[TD] Should return Case number 789[/TD]
[/TR]
[TR]
[TD]Descripton2[/TD]
[TD]456[/TD]
[TD][/TD]
[TD]222[/TD]
[TD][/TD]
[TD]555[/TD]
[TD]Formula?[/TD]
[TD] Should return Case number 852[/TD]
[/TR]
[TR]
[TD]Descripton3[/TD]
[TD]789[/TD]
[TD][/TD]
[TD][/TD]
[TD]333[/TD]
[TD]not returned[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Descripton4[/TD]
[TD]963[/TD]
[TD][/TD]
[TD]444[/TD]
[TD][/TD]
[TD]not returned[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Descripton5[/TD]
[TD]852[/TD]
[TD]555[/TD]
[TD][/TD]
[TD][/TD]
[TD]not returned[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]