Use Index() formula.

You can use the column and row numbers directly in the formula or use match to find them for you.
Your problem is that the first column does not have unique values.
I would add a helper column that counts the nth value in the first column.
(e.g. in your example you have the number 3 appearing three times the helper column would show 31,32,33 for each occurrence)
(I hope the attachment shows...)

http://excelexperts.com/sites/default/files/Index.xls